Click here to Skip to main content
15,917,005 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
hello friend I am working on a Online Index Recommendations for High-Dimensional Databases Using Query Workloads I want to use my own index selection algo in project & i want to disable ready made automatic index selection tool of sql server that is autoadmin any one know how to stop it.please help me.
Posted
Updated 14-Aug-11 21:43pm
v2

1 solution

As I asked before, what tool are you referring to? From the sound of this question it feels like you're referring to the optimizer of the database (the one that makes the decision for the access path).

If that's the case, you cannot replace it with your own algorithm. However, what you can do for example is to use hints. These hints guide the optimizer to use specific strategy on a table, for the query or for joining tables. For more information, see: Query Hints[^]
 
Share this answer
 
Comments
maheshpardeshi 19-Aug-11 5:49am    
i have a project in that project i want to search data without using index & with using index & i want to show difference between them how can i do this

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900