jwcolby
jwcolby at colbyconsulting.com
Tue Dec 15 10:08:58 CST 2009
In viewing an execution plan, as I hover over the index seek icon I see a bunch of information including estimated number of rows. This leads me to wonder whether SQL Server has statistics somewhere about the total number of actual data elements in each index. IOW how many data elements are in this field, as observed in the index for that field? When I am done with my indexing, I will have a single column index on every field, and if the information is available I could get a gross count for each field which would be useful for the client. -- John W. Colby www.ColbyConsulting.com