Re: Rule base optimizer selecting different execution path ( Tuning )

Brijesh There are few conditions where the optimizer will select CBO even when the optimizer_mode is set to rule. Do you have any objects in the schema with a parallelism 1 (tables and indexes) ? One of the common problem is that DBAs rebuild the index with higher parallelism and forget to

Re: Rule base optimizer selecting different execution path ( Tuning )

FWIR, if there is a tie between two indexes, oracle will use the index that was created/recreated most recently. Ron [EMAIL PROTECTED] [EMAIL PROTECTED] Karaoke: Japanese for migraine