optmize | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

optmize

When i retrive certain table x it fetchs, 2,30,000 records and its based on linked server. And i cant make to confined time bcos its already an hourly basis table whihc stores every user application usage information all our the world and it takes so much of time to retrive all the records. How can i optmize to reduce time Select applicationid, applicationusage from Apphrly inner join Allworldhrly on =Apphrly.applicationid=Allworldhrly .applicationid where Apphrly [email protected] Regards
Navin.d
Did you test if tables has adecuates indexes? Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Check the indexes and then try to use Index tunning Wizard
Hi Navin,
As said by Luis & Dinesh,
You can’t do much to optimise a normal select query.
You have to depend on Indexing.
I think have clustered index on applicationID Thats all!!!!
]]>