If the number of distinct values of a column is less than 1% of the
number of rows in the table, or if the values in a column are repeated more than 100 times, then the column is a candidate for a bitmap index.
a bitmap index on this column can out-perform a b-tree
index, particularly when this column is often queried in conjunction with other columns.[@more@]
number of rows in the table, or if the values in a column are repeated more than 100 times, then the column is a candidate for a bitmap index.
a bitmap index on this column can out-perform a b-tree
index, particularly when this column is often queried in conjunction with other columns.[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-966733/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-966733/
扫一扫
906
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
