March 30, 2005 at 2:57 am
Hi
When i executed a query containing inner join with morethan 3 tables, the retrieval becomes slow ( it takes 5-10 minutes). The main table contains over 10 lakhs of records and other tables are less than 2 lakhs of records. The main table is indexed with cluster-index and other tables are also indexed wherever necessary.
How to increase the speed of the query.
Please give your suggestion to increase the performance of my query.
Bye
Krish
March 30, 2005 at 6:37 am
Have you checked the execution plan to see if there are any obvious bottlenecks, table scans, excessive bookmark lookups, that sort of thing?
if that's all ok then I would start looking at whether the indexes are seriously out of whack and needing a rebuild, and also when the statistics were last updated.
Sorry I can't help more but it's hard to help without more information.
March 31, 2005 at 5:06 pm
Sounds like you are either missing clustered indexes, or your foreign keys aren't indexed, or your indexes are badly fragmented. If DBCC SHOWCONTIG doesn't identify any fragmented indexes to rebuild, use the Index Tuning Wizard to look at your query.
Gary
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply