Subject | one performance/index question |
---|---|
Author | Sasa Mihajlovic |
Post date | 2009-02-02T07:38:41Z |
Hi,
few days ago I was do the Database Statistics and in the report I have
some bad indexes, for example I have a field session which is represent
a fiscal year in table invoices. so do I need to index that field
because I have only 3-5 different values and I often use this field in
my sql statetmets like very important in where clausule?
Thanks in advance...
few days ago I was do the Database Statistics and in the report I have
some bad indexes, for example I have a field session which is represent
a fiscal year in table invoices. so do I need to index that field
because I have only 3-5 different values and I often use this field in
my sql statetmets like very important in where clausule?
Thanks in advance...