Re: Problem with sqlload and indexes under Oracle 8.0.5

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sun, 4 Jul 1999 03:04:03 -0400
Message-ID: <7ln19c$qkl$1@autumn.news.rcn.net>

Hi,

You must run ANALYZE with either the COMPUTE STATISTICS or ESTIMATE STATISTICS clause against the table after you have reindexed or the index won't be used.

regards
Jerry Gitomer

dalmond14_at_my-deja.com wrote in message
<7lit9t$hp8$1_at_nnrp1.deja.com>...
>
>
>We are populating an Oracle 8.0.5 database with
>data by perfoming a series of sqlloads. Prior to
>this the indexes are been dropped. When the load
>is complete the indexes are added back on. The
>indexes create fine, with no errors, but when we
>run queries against them the indexes are not
>used, a full table scan is done instead. If we
>then go into server manager and flush the shared
>pool, or bounce the database; bingo the indexes
>come into use again. Has anyone seen anything
>like this before, and give us a lead on what to
>tweak before we go crazy.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Jul 04 1999 - 02:04:03 CDT