November 30, 2005 at 4:21 pm
Hi,
Is there a hint not to use any indexes ? If yes, can you put a sample script ? I just want to compare diffrent indexing as well as to force query not to use any.
Thanks
November 30, 2005 at 4:30 pm
Why would you want a hint to force a query not to use indexes ? SQL Server will typically make the right judgement call if the query is optimal and if the stats are properly collected (of course there are other factors as well like hardware,memory etc.).
If you want to compare different indexing schemes, you can play with indexes or try out different index hints in the SQL statement itself.
November 30, 2005 at 4:37 pm
The reason why I want this hint is I suspect that we don't really need any indexes on this particular table (or maybe we don't need them for certain values in Where clause), but I can't play with indexes because this is production database.
December 1, 2005 at 6:59 am
indexes are used by the server to find data faster.
I doubt you might want the server to get the data slower or less efficiently.
in a complex query, you might add a hint to use a certain index because using a index determined by a query plan might be slower than a tuned query.
I think you might be confusing indexes with something else; could you explain further?
Lowell
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply