Index Organized Table in Oracle|IOT Oracle|Tech Coach

Опубликовано: 04 Октябрь 2024
на канале: Tech Coach
10,053
358

Index organized table is a variant of BTree Index which stores both Index and Data in the same Segment.
It is very useful for entities where the data is queried frequently using primary key as it removes the additional IO of accessing table data by Index row id.
The video explains IOT in details along with Organization Index Keyword, Including and overflow
#IndexOrganizedTable #IOT #Oracle