Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: REPOST: Encoding NULLs as sentinels/extents
A querry against null alwais causes a full table scan. Always try to work with
a date.
If you do not have a date in your databse field
insertet yet fill it for example with 1.1.1800 (if You have no start date
filled) or 31.12.9999 (if you have no end date filled)
and set this date as a default. Afterwards you do not have to querry agains
null.
mfg
frank
Received on Tue Dec 01 1998 - 09:57:06 CST