misi01 wrote: |
My impression (after googling) is that the answer is no, but .....
Can different partitions in a table have different indexes. For example, partition 1 might have an index on part_no, but partition 2 on sales_date. |
Code: |
CREATE TABLE some_tbl (Part_no interger NOT NULL, sales_date date NOT NULL, some_info varchar) in your.tablespc partition by (Part_no) ( part 01 value (02000000), part 02 value (04000000), part 03 value (06000000), part 04 value (08000000), part 05 value (10000000)); CREATE INDEX A ON some_tbl(part_no) ... CREATE INDEX B ON some_tbl(sales_date) ... |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours