This may be helpful. If the correct information is supplied the first time, it will help you find a solution, or at least an explanation, much sooner. http://www.catb.org/~esr/faqs/smart-questions.html#beprecise On Tue, 22 Feb 2005 09:12:13 -0500, Powell, Mark D <mark.powell@xxxxxxx> wrote: > I think displaying the SQL with explain plans for the two versions would be > helpful. What indexes with columns exist on pf_document_rv? Is the data in > r_object_id stored as mixed case, upper? > > -- Mark D Powell -- > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l