Re: Query uses index in SQLPlus but not in PLSQL

From: vari <rik.vanthuyneNOriSPAM_at_iname.com.invalid>
Date: Tue, 25 Jan 2000 03:59:00 -0800
Message-ID: <1c31fd54.8afbbf99@usw-ex0109-066.remarq.com>

Oracle chooses an execution plan based on the information in your select statement. If you are using values instead of bind variables Oracle might use another execution plan because it has more information on how to process the SQL.

Bye

Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Tue Jan 25 2000 - 05:59:00 CST