I expect about 1000 rows to return , and their is one type of index defined which is traffic1

each table have millions of records

any thing else ?

Everybody is not perfect in everything and as for my job , i am not DB expert , i am Linux administrator so as far my concern forums are made...

thanks all ,

my jobs run successful but no effect on DB performance , may be i need to look in to other things

I had perform re indexing

updated statistics

and...

Thanks All,

Tonight i will try to follow the support page and perform reindexing and reindexing i will do statistics on database

if i am doing wrong or some thing bad please...

ok let me try with print statement and see the results and let you know , if you can write script for my specific database it will be very helpful...

do i need to make any changes in to this script run as it is

thanks for wonderful reply

So please give me your suggestions weather my direction is right or wrong

here i have application use for billing for customers accounts

the application which is...

Dear deepak ,

thanks for your use full reply , here situation is soo much critical and i am afraid to execute this query on my Database , because it is...