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@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l