| Subject | Exclude records from index |
|---|---|
| Author | ck1625 |
| Post date | 2011-06-06T04:55:16Z |
Hi,
is it possible to create an index, but exclude records with values NULL and 0 in the index column for the index?
I have a log table with millions of records, but maybe only 5-10% have a value in this specific field. And if I ever do a query using this value, only records with values <> NULL or 0 are relevant.
cu Christian
is it possible to create an index, but exclude records with values NULL and 0 in the index column for the index?
I have a log table with millions of records, but maybe only 5-10% have a value in this specific field. And if I ever do a query using this value, only records with values <> NULL or 0 are relevant.
cu Christian