| Create partition Index on Non-partition column [message #690344] |
Mon, 28 April 2025 07:20  |
 |
deepakdot
Messages: 93
Registered: July 2015
|
Member |
|
|
Greetings !
Lets say table definition is :
CREATE TABLE TEST_PART
(COL1 NUMBER(10),
COL2 NUMBER(10),
COL3 NUMBER(10));
Table is partitioned (Range Partition ) on 2 columns Col1 and Col2.
When i have partition index on both Col1 and col2 as index column, its good.
My Que is : My Question is, does it benefit if WE create a LOCAL Partition index but the columns in the table is not partitions.
i.e. If I am creating an index on COl1 and COL3 ( where Col3 is not partition key column), is it good to have this as a partition index or we should keep this as a non- partitioned index ? What is the recommendation.
CREATE INDEX TEST_PART_II ON TEST_PART (
COl1 ASC
,COL3 ASC
) LOCAL;
[Updated on: Mon, 28 April 2025 08:05] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
