Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index on status field?

Re: Index on status field?

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Sun, 10 Apr 2005 18:05:53 +1000
Message-ID: <4258DE61.8000400@iinet.net.au>


Martic Zoran apparently said,on my timestamp of 10/04/2005 4:45 PM:  > snippage
> nice to check 0 and NULL. Also I trust the app that
> only 0 and NULL will be in status field :)

Jeez, you're brave...

> You need to have a crazy reason to do rebuilding where
> you can justify that you will save some time on later
> executed SQL's, or space and memory are issues on the
> system.

Or a bug in the index code...

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Apr 10 2005 - 04:12:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US