Data Distribution & Estimated row count

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi!

Iīd like to make my questions more concrete. I want to access some statistical information used by query optimizer.

1. How can I access distribution statistics?

I canīt store the result of DBCC SHOW_STATISTICS since that command returns more than one result set.

2. How can I estimate the number of tuples that will be returned by query?

This information exist in query plan but I canīt access that value.

ps. I canīt believe that there is no easy way to access these values. So I donīt want to print the output of DBCC command/Execution plan to a text file and to process that file.

Cheers, FA.

-- Anonymous, July 02, 2001

Answers

Fuat,

Distribution steps are only recorded for the first column. There is no more information to see.

Good Luck,

Eric

-- Anonymous, July 02, 2001


Moderation questions? read the FAQ