Re: Queries vs Indexes and the 10053

From: Don Seiler <>
Date: Fri, 1 Feb 2008 15:04:25 -0600
Message-ID: <>

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
-- Received on Fri Feb 01 2008 - 15:04:25 CST

Original text of this message