Re: Why my index is not used?

From: What's in a namespace <whatsin_at_xs4all.nl>
Date: Wed, 17 Jan 2007 16:46:07 +0100
Message-ID: <45ae44c8$0$331$e4fe514c@news.xs4all.nl>

A little bit off topic, sorry for that:

"sybrandb" <sybrandb_at_gmail.com> wrote in news:1169042411.060180.91720_at_v45g2000cwv.googlegroups.com...

> > INDX_RESULT_1 RUNID 1
> > INDX_RESULT_1 SCRIPTID 2
> > INDX_RESULT_1 STARTSTAMP 3
> > INDX_RESULT_1 ERRORCOUNT 4
> >
> > INDX_RESULT_2 RUNID 1
> > INDX_RESULT_2 SCRIPTID 2
> > INDX_RESULT_2 STARTSTAMP 3
> >
> > INDX_RESULT_3 RUNID 1
> > INDX_RESULT_3 SCRIPTID 2
> > INDX_RESULT_3 STARTSTAMP 3
> > INDX_RESULT_3 STEPORDER 4

>(indices need to be revised too)

Sybrand, just to check: isn't the second index obsolete, for all columns are already in the other indices? Or is there a problem with null columns (ERRORCOUNT, STEPORDER) if the second index is removed? (I'm not a DBA, just a question, thanks in advance)

Shakespeare

>Hth>
>--
>Sybrand Bakker
>Senior Oracle DBA
Received on Wed Jan 17 2007 - 09:46:07 CST