Indexing on Partition table with Key Column
oracle 19c I would like to know the approach for indexing on partition table on column date.
is the recommended to have indexes several indexes on partition table along with key column.
IDX0-> Date(partition column)
IDX1->Date(partition column) along with other column job id
IDX2->Date(partition column) along with other additional column.
I would like to know whether indexing on particular partition column will suffix the requirement?