|
|
Posted by Alexander Kuznetsov on 04/17/06 03:44
Serge Rielau wrote:
> Struggling to research bookmarks I ran into:
> http://msdn2.microsoft.com/en-US/library/ms180920(SQL.90).aspx
> "Bookmark Lookup is not used in SQL Server 2005. Instead, Clustered
> Index Seek and RID Lookup provide bookmark lookup functionality."
> Cool, let's bypass that one.
Interesting. My understanding is that SQL Server 2000 does not store
clustering factor as part of statistics, and the reason is simple: it
makes no sence for bookmark lookups. However, for more efficient RID
lookups, it would make perfect sence to both calculate clustering
factor as part of statistics gathering and have the optimizer use it.
Yet I tried to google up "clustering factor"+"SQL server" and that
brought up nothing relevant to SQL Server.
Does SQL Server 2005 optimizer use clustering factor, and if yes,
what's the proper word for it?
Navigation:
[Reply to this message]
|