Re: select counts versus insert/select counts

From: "Rumpi Gravenstein" <rgravens@xxxxxxxxx>
To: Rob.Dempsey@xxxxxxxxxx
Date: Fri, 19 Oct 2007 09:10:01 -0400

That's an excellent idea - I've seen this as well.  If the index is
corrupted, the indexed search will not return the correct results.  In my
case rebuilding the index fixed the issue.

On 10/19/07, Rob Dempsey <Rob.Dempsey@xxxxxxxxxx> wrote:
>
> I have seen different counts when there is an index on the table and
> oracle has not maintained the index.
>
> Check what the execution plan is.  If it is using a index then try the
> same SQL with a /*+ FULL(t)*/ hint
>
> Rob
>
>

References:

select counts versus insert/select counts
From: Michael . Coll-Barth

RE: select counts versus insert/select counts
From: Rob Dempsey

Re: select counts versus insert/select counts

Other related posts: