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 to tune
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
= TRUE
for
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
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 on
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-6783
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
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_caching,optimizer_index_cost_adj
PMFJI
How about optimizer parameters
(optimizer_index_caching,optimizer_index_cost_adj)?
optimizer_index_caching=0 Are these reasonable values?
optimizer_index_cost_adj=100
sorry for the space everyone ms outlook 101 is a class I *badly* need
like how do I reply in plain text with
