Indef usage

From: Guruju,Narendra <NGURUJU_at_cerner.com>
Date: Fri, 3 May 2002 14:54:24 -0500
Message-ID: <D15ED542E12BD3119FFE00805F6551F00DEDA96E@mailwhqnews.cerner.com>

It is on diff databases version 8.1.6 and 8.0.5

-----Original Message-----
From: Daniel Morgan [mailto:dmorgan_at_exesolutions.com] Posted At: Friday, May 03, 2002 2:30 PM
Posted To: comp.databases.oracle.server
Conversation: Index usage
Subject: Re: Index usage

"Guruju,Narendra" wrote:

> With out putting a hint in the query, is it possible to make a query
> choose a particular index. The query is in a 3rd party application and
> can not be modified, but the testing shows that if it uses a different
> index on the table, it would run lot faster. Also the optimizer mode
> used by the application is RULE.
>
> TIA,
> Narendra

What version of Oracle?

Daniel Morgan Received on Fri May 03 2002 - 14:54:24 CDT