query using different indexes now

From: <gplagge_at_my-dejanews.com>
Date: Wed, 03 Feb 1999 17:16:42 GMT
Message-ID: <79a09h$m64$1@nnrp1.dejanews.com>

Hi,
We have some selects that have changed which indexes they are using, according to Explain Plan, and also according to a big decrease in performance.

The queries we are concerned about use a RULE hint in them, so underlying changes in number of rows, etc. shouldn't affect them, right?

The queries have not been modified (they are in stored procedures). The schema has not changed for these tables and indexes. And yet, explain plan says they are using slower indexes now.

We are running 8.0.5.1.0 on NT.

Any ideas?

Thanks,
Gene Plagge
Manager, International Database Services WorldxChange, Inc.
gplagge_at_hotmail.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 03 1999 - 11:16:42 CST