any updates?

I tested both the indexes. Both of them took 2 seconds to complete the execution.

But it is varying in IO. I have already posted the logical read details. Can you...

Grant,

can you provide me the link of your article?

I did some more research about FORWARD & BACKWARD scan.

Test #1:

select name,id from sp_help sysobjects

order by id

Query Plan:

|--Clustered Index Scan(OBJECT:([IPStatic].[dbo].[sysobjects].[sysobjects]), ORDERED FORWARD)

Test #2:

select name,id from sp_help sysobjects

order by...

Total Logical Read: 65818

Details:

Tables Logical Read

summary1

exception2

funds6466

Mapping4309

identifier134

#symb_m010070100033911052112

#symb_m010070100033911057

Worktable12146

#symb_m010070100033911057

asset_alloc4232

Worktable16314

#symb_m010070100033911057

asset_alloc4216

Worktable12156

#symb_m010070100033911057

exception8392

Worktable11904

#symb_m010070100033911052295

feed_output474

exception4

Worktable2250

Worktable1269

#symb_m010070100033911050

feed_output0

exception2

Worktable27

Worktable17

#symb_m010070100033911059

feed_output716

Worktable1376

#symb_m010070100033911052295

feed_output36

exception4

Worktable232

Worktable1269

#symb_m010070100033911050

feed_output0

exception2

Worktable27

Worktable17

#symb_m010070100033911059

Worktable1376

#symb_m010070100033911057146

feed_output17

Worktable11962

#symb_m010070100033911052295

feed_output710

exception4

Worktable2233

Worktable1269

#symb_m010070100033911050

feed_output0

exception2

Worktable27

Worktable17

#symb_m010070100033911052295

feed_output474

exception4

Worktable2250

Worktable1269

#symb_m010070100033911050

feed_output0

exception2

Worktable27

Worktable17

Total Logical Read: 62684

Details:

Tables Logical Read

summary1

exception113

funds6,466

Mapping4309

identifier134

#symb_m010070100033911052112

#symb_m010070100033911057

Worktable12146

#symb_m010070100033911057

asset_alloc4,232

Worktable16314

#symb_m010070100033911057

asset_alloc4,216

Worktable12156

#symb_m010070100033911057

exception4,267

Worktable11,904

#symb_m010070100033911052295

feed_output474

exception113

Worktable2250

Worktable1269

#symb_m010070100033911050

feed_output0

exception113

Worktable27

Worktable17

#symb_m010070100033911059

feed_output716

Worktable1376

#symb_m010070100033911052295

feed_output36

exception113

Worktable232

Worktable1269

#symb_m010070100033911050

feed_output0

exception113

Worktable27

Worktable17

#symb_m010070100033911059

Worktable1376

#symb_m010070100033911057146

feed_output17

Worktable11,962

#symb_m010070100033911052295

feed_output710

exception113

Worktable2233

Worktable1269

#symb_m010070100033911050

feed_output0

exception113

Worktable27

Worktable17

#symb_m010070100033911052295

feed_output474

exception113

Worktable2250

Worktable1269

#symb_m010070100033911050

feed_output0

exception113

Worktable27

Worktable17

I am...

I am feeling like blind now...yes. I dont know who is reading my post and who comes online....earlier it will show who is online now under each section and each...

for #1, I have noticed backward scan

for #2,I have noticed forward scan

which one is good? i got confused.....

can you tell me how should i know the cost of both indexes ?

I tested the below indexes

create nonclustered index sk_exception on exception(feed_num,err_cd,symbol)

create nonclustered index sk_exception on exception(symbol,err_cd,feed_num)

I didn't see any difference between them. But which combination will give good performance in the...

Thanks Bob for giving the workaround!

But i am looking for specific commands or the correct way to get it.

I will give you some more example.

--------------------------------------------------

create proc p2_t

(

@feed_num int

)

as

begin

select a.*

from exception a ,err_lkp b

where a.err_cd=b.err_cd

and a.err_cd <> 36

and a.feed_num = @feed_num

select symbol, feed_dt =...

Sure.

create proc p1_t

as

begin

--#1)

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

...

I did my master degree in INDIA. My master degree name is MCA(Master in Computer Application)

I will check it out student visa.

my name only.

you can see one more karthikeyan here. Probably you can see sql2000 --> TSQL --> forum topic = "1=1" which you answered just now.

my name also karthikeyan. His...

Thanks Gail for your tips.

steveb,

i dont have any limitations,if i get admission(part time) in good university, i will join immediately.

Steve,

still i am facing the same issue, i have to click...