I have a query that needs to look at the records in a table where fieldx is null. It would be nice if I could index this field because the number of null values are 79K and the number of rows in the table is 12M.

Since less than 1% of the rows would be returned, I think that an index would help.

Is there a work around so that I could sort of index this column? Function-based index maybe?

Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]



Oracle LazyDBA home page