Can anybody explain me
When should we use global indexes ?
When should we use local indexes ?
Which indexes needs to be dropped before loading into table ?
Thanks
Asked
Active
Viewed 88 times
1 Answers
0
Which indexes needs to be dropped before loading into table ?
- The unique ones. According to Oracle's documentation there is no way how to bulk-load data into table, having PK, UK constraints disabled and unique indexes invalidated. Even if you do both (disabling, invalidation) you will get ORA- error in insert anyway. The "official" recommendation is really to drop UK indexes before the load. And re-create the index afterwards.
ibre5041
- 4,903
- 1
- 20
- 35
-
When should we use global indexes ? When should we use local indexes ? – Srinivas P Aug 28 '14 at 12:44
-
It's not really easy to tell. Maybe you will find something useful in "Oracle Database Data Warehousing Guide" – ibre5041 Sep 03 '14 at 11:34