Subject | How to calculate Index selectivity ? |
---|---|
Author | Tanno Vorenkamp |
Post date | 2003-09-16T11:13:18Z |
Hi All
We are using Firebird 1.0
and in the manual I read the following
"You should recalculate the index selectivity if a change to the table affects the average
distribution of data values"
My question: How should I recalculate the index selectivity ?
and for what values of the statistics should I conclude that the index is not selective enough ?
best regards
Tanno
[Non-text portions of this message have been removed]
We are using Firebird 1.0
and in the manual I read the following
"You should recalculate the index selectivity if a change to the table affects the average
distribution of data values"
My question: How should I recalculate the index selectivity ?
and for what values of the statistics should I conclude that the index is not selective enough ?
best regards
Tanno
[Non-text portions of this message have been removed]