creating reverse key indexes on huge tables which are indexed
Hi,
We are planning for creating reverse key indexes on huge tables which are indexed, based on a running serial number and undergoes heavy dml operations in concurrent sessions like parallel eod.
I believe we can use reverse key indexes for huge tables .We are not using range queries on the indexed column. Hence should be Ok.
Ramesh
We are planning for creating reverse key indexes on huge tables which are indexed, based on a running serial number and undergoes heavy dml operations in concurrent sessions like parallel eod.
I believe we can use reverse key indexes for huge tables .We are not using range queries on the indexed column. Hence should be Ok.
Can any one please advise on this ? Which is best practice to avoid wait events when concurrent jobs running.
Thanks in advance.
Ramesh
0