Re: Queries vs Indexes and the 10053

From: Don Seiler <don_at_seiler.us>
Date: Fri, 1 Feb 2008 15:04:25 -0600
Message-ID: <716f7a630802011304h947550cjfdcec63ebf4f6fa@mail.gmail.com>

I did set optimizer_index_caching=90 and optimizer_index_cost_adj=10 in another development instance and the query went from the FTS to the index range scan as desired. I initially just set the optimizer_index_caching to 90 but the query still did an FTS after.

I think in the short term I'm going to set these parameters back to the values from last month. Then I'll do some fine-tuning with them in development in addition to looking at query/design issues.

--

Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 01 2008 - 15:04:25 CST

This message: [ Message body ]
Next message: J. Dex: "impdp with encryption on different source/target"
Previous message: Andrew Kerber: "Re: DBA Privileges and Developers"
In reply to: Don Seiler: "Re: Queries vs Indexes and the 10053"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message