Re: Oracle 8.0.6.2: SQL using contrants to replace bind variables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 03 Oct 2000 21:20:39 +0200
Message-ID: <1acktsodjq8d0k65rdk998udn5gk749msd@4ax.com>

On Tue, 03 Oct 2000 17:40:34 GMT, rcrozier_at_uia.net wrote:

>Problem:
>Executing the same SQL using constrants to replace bind variables is
>not producing the same query execution plan.
>
>When plug in number returns instantly by reading through index when
>plug in bind variable does full table scan. Any sugestions?
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Try to create histograms for the indexed columns analyze table <table_name> compute statistics for all indexed columns size 10;

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Oct 03 2000 - 14:20:39 CDT