求一本书的电子版,抱怨一下SQL Server Optimizer# Database - 数据库
j*n
1 楼
名字好像是 SQL Server Internals.
其中很详细地讲了一些关于 IAM 的问题。有没有哪位知道的?
要不谁有关于 IAM 的详细说明或者网址什么的也行。
俺现在对SQL Server Optimizer 极为不满,it can never guaranty you it will use
the right index even right after you rebuild your indexes and updated
statistics.
Microsoft always recommend that DO NOT USE index hint unless it is the last
resort, but if you could not guaranty me to use those indexes I have
carefully maintained, how can I get ride of those hints?!
组里面一位貌似大牛说可能是IAM的问题,俺得好好研究一下。嗯,就酱紫。
谢了先!
其中很详细地讲了一些关于 IAM 的问题。有没有哪位知道的?
要不谁有关于 IAM 的详细说明或者网址什么的也行。
俺现在对SQL Server Optimizer 极为不满,it can never guaranty you it will use
the right index even right after you rebuild your indexes and updated
statistics.
Microsoft always recommend that DO NOT USE index hint unless it is the last
resort, but if you could not guaranty me to use those indexes I have
carefully maintained, how can I get ride of those hints?!
组里面一位貌似大牛说可能是IAM的问题,俺得好好研究一下。嗯,就酱紫。
谢了先!