Rule Based Optimizer

From: <amerar_at_iwc.net>
Date: 2 Mar 2005 12:07:33 -0800
Message-ID: <1109794053.741754.43830_at_g14g2000cwa.googlegroups.com>


Hi All,

The application I am in charge of has been optimized to use the rule based optimizer. I've been doing some tracing and would like some clarification.

What is the difference between a UNIQUE SCAN and a RANGE SCAN?

I'm lost as the to differences. Even the documentation does not really tell me the difference between them.

Thanks,

Arthur Received on Wed Mar 02 2005 - 21:07:33 CET

Original text of this message