Chris,

After creating the below index to the temp table, the query took 2 seconds only.

create nonclustered index id1 on #symb_map(sec_id,symbol)

Thanks for your help!

Thanks to all!

create proc p1_t

as

begin

select a.sec_id, b.symbol, b.prtf_id, c.p_id,a.flag into #symb_map

from funds a, Mapping b, p_identifier c

where a.sec_id = b.symbol

and...

I have executed the scirpt seperately.

It took 1 second only.

I put that statement in a procedure, it took 6 seconds.

Thanks Chris and sqlmaster!

I am facing a starnge problem while executing the below query. if i execute it seperate it took just 1 second to complete the execution. If i...

NOT IN:

Select sec_id, symbol

from fund

where symbol not in ( select symbol from exception where err_cd in (20,30))

NOT EXISTS:

Select sec_id,symbol

from fund f

where not exists ( select * from exception e where...

Ramesh,

i used exactly the same query.

Due to security reason,Here i posted sample table and records.

But the scenario which i posted is my requirement.

Any inputs?

Sorry! A little late here.

Thanks for all your feedback!

I would like to do some research about 'OPTIMIZER'. But frankly speaking i haven't decided what to do and the other...

Sergiy,

you mean the above statements within the procedure wont hold locks ?

I think i have phrased my question wrongly, may be if i ask like locks...

I don't know if I am considered a regular or not. I am on the site daily.

I'd be honored and proud if you'd like to send one my way!

I think i should turn on

set statistics io on

&

set statistics time on

right ?

Now i got access to both the server.

how should i check the disk speed ?

how should i look CPU speed ? ( from Task manager window ? )

SELECT CHARINDEX( 'Funder', routingheader ),

CHARINDEX( 'Industry', routingheader...

Thanks Gila,

I forgot to ask....

what do you mean by Hard disk speed and CPU speed ? is there any difference between them ?

Gila,

what do you mean by database activity ?