Skip to content
New issue

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

Support for segment eliminations for columnstore indexes #40

Open
Ligtorn opened this issue Nov 18, 2016 · 0 comments
Open

Support for segment eliminations for columnstore indexes #40

Ligtorn opened this issue Nov 18, 2016 · 0 comments

Comments

@Ligtorn
Copy link

Ligtorn commented Nov 18, 2016

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant