| Subject | Limit for Index Statistics? |
|---|---|
| Author | dade2000 |
| Post date | 2004-02-11T16:36:40Z |
Hello
There is a value of statistics for check if an index is usefull or table
scann is better?
es.
STAT >=0.003 index isn't usefull (TABLE SCAN is better)
STAT <=0.0029 index is usefull (Indexed search is better)
Many Thanx
Daniele
There is a value of statistics for check if an index is usefull or table
scann is better?
es.
STAT >=0.003 index isn't usefull (TABLE SCAN is better)
STAT <=0.0029 index is usefull (Indexed search is better)
Many Thanx
Daniele