Oracle-L: Index Partitioning

From: Leonard, George <george.leonard_at_farnell.com>
Date: Tue, 29 Oct 2002 12:38:25 -0800
Message-ID: <F001.004F6C3C.20021029123825@fatcity.com>

Hi all

System is Siebel

Ok I got a couple of tables about 6 GB big, up to 10 million rows.

Some of the tables come out of the box with 30+ indexes, now for those not aware Siebel does not support the dropping of any indexes.

I do though know what my indexes is that are hit the most and was thinking of partitioning them and or maybe the tables.

Firstly

If I was to partition only the table, Would I have to make any changes to the currently indexes other than rebuilding them.

Second. Is it possible for to only partition a selected index. Here I keep on seeing local and global partitions - indexes. From what I can determine Global is bad news.

How do I do local, what consideration are there.

Some of the tables/indexes considered is orders, orderliness, shipments, shipments lines, all with well over 5 million records each.

The queries is not date specific but more account or contact specific for the order if that's helps.

I was considering partitioning on order_id but again it looks best to use hash partitioning since there is not real way of saying the queries will always go this way.

Basically trying to reduce the work for Oracle to get to data. All my queries is already using the best possible index.

Comment, suggestions

thx

George

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)

Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za <http://www.didata.co.za>

You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leonard, George
  INET: george.leonard_at_farnell.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Tue Oct 29 2002 - 14:38:25 CST