Re: Performance Problems

From: Barry Bulsara <bbulsara23_at_hotmail.com>
Date: 16 May 2007 07:27:38 -0700
Message-ID: <1179325658.460700.324510@p77g2000hsh.googlegroups.com>

On May 16, 12:55 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net> wrote:
> On Wed, 16 May 2007 02:35:04 -0700, mjmather wrote:
> > Anyone have suggestions, comments or considerations?
>
> Cluster the tables.
>
> --http://www.mladen-gogala.com

Mladen, I was not aware that this until you wrote this. Is the reason for you saying cluster the tables to reduce IO as written on this web page.

http://www.dba-oracle.com/oracle_tip_hash_index_cluster_table.htm

If so, I have learned something new today. I am a developer often uses Oracle, I am not a DBA but I do write database scripts. Thank you
Barry Received on Wed May 16 2007 - 09:27:38 CDT