Re: Oracle 9.0.1.0.0 and the indexes ...

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 16 Jun 2003 19:25:04 +0200
Message-ID: <5vqrev43vvid2rdkj2hvcpkkstvc2pi5kv@4ax.com>

On Mon, 16 Jun 2003 13:33:49 +0000, logiclin <member31237_at_dbforums.com> wrote:

>Anybody know what's wrong with this index ?

Nothing, you might not have analyzed it. Also it strikes me you seem to have parallel query enabled. Without further specifics from your side the only thing I can tell for now, is that Parallel Query is making a full table scan cheaper. Seems you just get what you ask to do it, and you shouldn't start shouting at the optimizer.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jun 16 2003 - 12:25:04 CDT