PMFJI
>>How about optimizer parameters
(optimizer_index_caching,optimizer_index_cost_adj)?
optimizer_index_caching=0 <
Um no probably not. O_i_c says (in Niall english) what percentage of my
index blocks are likely to be in memory rather than on disk. The
*baseline* for this is BCHR (or say
Title: RE: Query Tuning Help
Mladen,
Thanks for your response. Comments are in-line.
>>Do you have "query rewrite" privilege?
Yes.
>>What is the query_reqrite_inegrity set to?
TRUSTED.
>>How about optimizer parameters (optimizer_index_cach
David,
I would probably not try to tune a query to make it use an index but tune a query to
make it run faster - I have had recently a nice example, a join between a 500K row
table and two 2K row tables (returning about 2K rows too) was running faster with FTS
(followed by hash joins) on _ALL
Title: Query Tuning Help
The
FILE_DTS column is VARCHAR2(12) NOT NULL and has data in the following
format: 07220301.
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Solutions Phone: 919-466-6723
Cell: 919-412-8462
Pager: [EMAIL PROTECTED]
Fax: 919-466
Do you have "query rewrite" privilege? What is the
query_reqrite_inegrity set to? How about optimizer parameters
(optimizer_index_caching,optimizer_index_cost_adj)? Is everything
analyzed?
On 10/27/2003 10:34:26 AM, David Wagoner wrote:
I'm trying to tune the following query to use an index o
Title: Query Tuning Help
Tom,
Thanks
for the init.ora parameter tips, I consulted the docs and did that first
:-). It just seems that the CBO would rather use an index, even though I
know that's not always the case.
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Title: Query Tuning Help
David,
The
calculation "(> SYSDATE - 35)" is not causing the problem. The
To_Date(a2.file_dts, 'mmddyyhh24miss') is.
You
said you created a function based index. I think you also need to
set:
Query_ReWrite_Integrity =
TRUSTEDQuery_ReWrite_Enabled
because its not always faster to use an index. try using a hint for the index and see
which runs better.
>
> From: David Wagoner <[EMAIL PROTECTED]>
> Date: 2003/10/27 Mon AM 10:34:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Query Tuning Help
>
> I'm trying