How can I use an index?
From: Scott T. Johnson <sjohnson_at_ibm.net>
Date: 1997/03/31
Message-ID: <01bc3dde$f3ef1fa0$c74948a6_at_7l603>#1/1
Date: 1997/03/31
Message-ID: <01bc3dde$f3ef1fa0$c74948a6_at_7l603>#1/1
I have a table of approx. 2 million records. 10% of the records have an null value in a particular field. The remainder of the records of unique values in the field.
How can I use an index
if the field is null.
Ex) SELECT COUNT(*)
FROM TABLE
WHERE FIELD IS NULL;
If I run this through explain plan, it doesn't use the index. How can I force the use of index.
Scott Received on Mon Mar 31 1997 - 00:00:00 CEST