Home » SQL & PL/SQL » SQL & PL/SQL » when partitioning the table should the partitioning must also happen to indexes assiociated with tab (oracle 10gR2)
when partitioning the table should the partitioning must also happen to indexes assiociated with tab [message #344788] Mon, 01 September 2008 04:53 Go to next message
viva
Messages: 2
Registered: July 2008
Location: india
Junior Member

Hi All,

i wanted to perform range partitioning on table which contains indexs on it.Please find the table syntax below.If i want to perform range(weekly) partition with Time1 as the partition key should i also partition the index i.e Quotation_ID .Please help.

CREATE TABLE history( Time1 DATE NOT NULL, Total NUMBER(10,2), SQLString clob, tObjectID VARCHAR2(35), Views VARCHAR2(50), Quotation_ID NUMBER (10), ND
A_ID NUMBER (10), AGI_ID NUMBER (10), RIC VARCHAR2(50) DEFAULT NULL, Asset_type VARCHAR2(30), Tag NUMBER (10), Database_ID Number(5))
);

ALTER TABLE history ADD CHECK(Quotation_ID BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(NDA_ID BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(AGI_ID BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(Tag BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(Database_ID BETWEEN -32767 AND 32768);
CREATE INDEX p_index ON history (quotation_id);

Exit;
Re: when partitioning the table should the partitioning must also happen to indexes assiociated with [message #344839 is a reply to message #344788] Mon, 01 September 2008 06:31 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Just search for this keyword in google and you should be able to come to a conclusion which will best for you. Because the answer depends on the index key and other factors?

"partitioned tables with global or local indexes".

Regards

Raj
Previous Topic: concatnating the second table data in single column of first table
Next Topic: In Date field null value gets stores like '01/01/0001'
Goto Forum:
  


Current Time: Thu Dec 08 16:10:11 CST 2016

Total time taken to generate the page: 0.14795 seconds