Re: Oracle 8.0.5 Optimiser

From: Ross Mohan <skipdext_at_ix.netcom.com>
Date: Sat, 27 Nov 1999 00:58:30 -0500
Message-ID: <81nrs0$t6h$1@nntp4.atl.mindspring.net>

michael_bialik_at_my-deja.com wrote in message <81k8gf$5oh$1_at_nnrp1.deja.com>... <snip of FTS stuff>

> My tech.support people told me to use optimezer_goal = first_rows
> in my init.ora to "push" optimizer in using indexes.
>
> HTH. Michael.

OTOH, it may not help. this may be a DSS/reporting db and he may not want to push toward nested loops ( i.e. first rows ) data access paths, IMHO,
AFAIK, YMMV,WTF,SOL,COB,OK, et cetera. Received on Fri Nov 26 1999 - 23:58:30 CST