|
-
Index/performance tuning
I have a below query:
SELECT * FROM BUSINESS_PL
WHERE ADDRESS IS NULL;
from the above table, in the explain plan, it does a full table scan. but the cost is very low b/c the table had less than 100 records. Any way, the question is "can we put the index on the ADDRESS column"??? even the column is NULL???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|