Do we need an index on partition key in partition table ?
Hi,
In our DWH environment, we need few partitioned tables based upon the date columns and tuning advisor is recommending to create an index on the partitioned key ?
Is it recommended to have index( global or local ) in partitioned table ?
BR,
Anurag
In our DWH environment, we need few partitioned tables based upon the date columns and tuning advisor is recommending to create an index on the partitioned key ?
Is it recommended to have index( global or local ) in partitioned table ?
BR,
Anurag
0