RE: statement tuning ?

From: Ken Naim <ken_at_clubmom.com>
Date: Sat, 1 May 2004 23:16:35 -0400
Message-ID: <80C5610EF23BD411935200508B5C35EB046F14AC@cmiechange>

I have seen tremendous improvements using the CBO and analyzing all tables in a Siebel database.

While using the RBO our OLTP type queries were measured in minutes and after analyzing and using the CBO, execution time dropped to several seconds; a 30-60 fold increase in performance. Our key tables S_Contact, S_contact_x drove most of the queries and had approximately 4 million records.

Once we were on the CBO we felt our hands were untied and we started to add function based indexes for case insensitive searches, partitioning etc so our execution time for most queries became sub-second. Analyzing Siebel's EIM_* data load tables decreased load times by an order of magnitude when dealing with hundreds of thousands to millions of records.

Siebel was not happy to say the least and they said they wouldn't support us, my company decided such a performance gain was worth canceling support so we got the performance increase and saved ourselves a lot of cash at the same time.

Ken Naim

-----Original Message-----

From: David Green [mailto:thump_at_cosmiccooler.org] Sent: Saturday, May 01, 2004 3:20 PM
To: oracle-l_at_freelists.org
Subject: RE: statement tuning ?

Tim, thank you very much...I will look into your suggestions further! - David Green

-----Original Message-----

From: Tim Gorman
Sent: Saturday, May 01, 2004 1:47 PM
Subject: Re: statement tuning ?
David,
I figured I might as well respond according to expectations and respond = with
a short novel... :-) My apologies in advance for my deplorable lack of brevity...

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Sat May 01 2004 - 22:14:00 CDT