|
|
|
Junior Member
 
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Hi,
Can anyone tel me ,
can i careate the Secondray Index on Primary Indexing Columns ?
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 6:49:01 AM
Posts: 180,
Visits: 578
|
|
Hello,
No you can't, doing so will raise an error "Two indexes with the same columns". Following are couple of examples:
CREATE TABLE Table1 (Col1 INTEGER, Col2 INTEGER) UNIQUE PRIMARY INDEX (Col1), INDEX (Col1);
CREATE TABLE Table1 (Col1 INTEGER, Col2 INTEGER) PRIMARY INDEX (Col1), INDEX (Col1);
Regards,
Adeel
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/17/2008 6:46:55 PM
Posts: 9,
Visits: 14
|
|
you can use Partition Primary Index (PPI)
Thanks,
atadaret
|
|
|
|