Local Vs Global Partitioned Index in Oracle 11g
Автор: Tech Coach
Загружено: 2018-02-13
Просмотров: 36528
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved.
Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
#OraclePartitioning #IndexPartitioning #TechCoach
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: