如何禁用SQL的自动管理工具 [英] how to disable auto admin tool of sql

问题描述

你好朋友，我正在研究使用查询工作量的高维数据库的在线索引建议我想在项目中使用自己的索引选择算法，并且要禁用自动管理SQL Server的现成自动索引选择工具一个人知道如何停止它.请帮助我.

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.

推荐答案

正如我之前所问的，您指的是什么工具?从这个问题的声音看来，您好像是在指数据库的优化器(决定访问路径的优化器).

如果真是这样，您将无法用自己的算法替换它.但是，例如，您可以做的就是使用提示.这些提示指导优化器在表上使用特定策略，进行查询或联接表.有关更多信息，请参见:查询提示 [

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[^]

这篇关于如何禁用SQL的自动管理工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！