We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
When you work with column store indexes it is very important to see how many segments gets eliminated.
it would be great if you added that to the tables, and summarized it on table level. This is some output from SQL 2016
Table 'BKAmountsColumnStore'. Scan count 11, logical reads 8484, physical reads 0, read-ahead reads 0, lob logical reads 165597, lob physical reads 1, lob read-ahead reads 72296. Table 'BKAmountsColumnStore'. Segment reads 38, segment skipped 4091. Table 'TradesColumnStore'. Scan count 16, logical reads 22083, physical reads 0, read-ahead reads 0, lob logical reads 7603, lob physical reads 0, lob read-ahead reads 3907. Table 'TradesColumnStore'. Segment reads 10, segment skipped 1106.
Also thanks for this awesome tool, it ready helps with my work. This is something management studio should have as native support
The text was updated successfully, but these errors were encountered:
No branches or pull requests
When you work with column store indexes it is very important to see how many segments gets eliminated.
it would be great if you added that to the tables, and summarized it on table level. This is some output from SQL 2016
Table 'BKAmountsColumnStore'. Scan count 11, logical reads 8484, physical reads 0, read-ahead reads 0, lob logical reads 165597, lob physical reads 1, lob read-ahead reads 72296.
Table 'BKAmountsColumnStore'. Segment reads 38, segment skipped 4091.
Table 'TradesColumnStore'. Scan count 16, logical reads 22083, physical reads 0, read-ahead reads 0, lob logical reads 7603, lob physical reads 0, lob read-ahead reads 3907.
Table 'TradesColumnStore'. Segment reads 10, segment skipped 1106.
Also thanks for this awesome tool, it ready helps with my work. This is something management studio should have as native support
The text was updated successfully, but these errors were encountered: