Created
May 10, 2011 23:55
-
-
Save hmcfletch/965645 to your computer and use it in GitHub Desktop.
A list of helpful SQL queries
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Show the coverage of a partial index | |
SELECT COUNT(DISTNICT(SUBSTR(<column>,1,<partial index length>))) / COUNT(DISTINCT(<column>)) * 100 FROM <table>; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment