November 4, 2011 at 1:11 am
Hi,
Greetings!!!
How we can Improve the Performance of a Query WIthout creating Indexes?
November 4, 2011 at 1:40 am
Without more detail that is almost impossible to answer:
a) What is the query?
b) what indexes are there currently?
c) Why do you not want to create indexes?
With some of that informations available there may be some things you can do.
Mike John
November 4, 2011 at 2:14 am
Hi John,
I dont have permission to create Index.
In Execution plan its giving Table Scan only..
what are the other way's to improve the performance of the query?
November 4, 2011 at 2:56 am
If it's a table scan, there's probably an index missing. Speak with the DBA about getting the necessary indexes added.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 4, 2011 at 8:29 pm
sarvade.inder (11/4/2011)
Hi John,I dont have permission to create Index.
In Execution plan its giving Table Scan only..
what are the other way's to improve the performance of the query?
To add to Gail's suggestion... there may be an index available that's not being used because of the way the query has been written. Google for "sargable sql" (without the quotes) and see one example as to why a Table Scan might be used instead of an Index Seek.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 5, 2011 at 2:23 am
Better suggestion. Post the query and the table and index definitions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply