IOT Table
An IOT keeps its data stored according to the primary key column values for the table.IOTs store the data as if the entire table was stored in an index. Anormal index only stores the indexed columns in the index; an IOT stores all of the table’s columns in the index As the table’s data is stored as an index, the rows of the table do not have physical RowIDs. Therefore, you cannot select the RowID pseudocolumn values from an IOT.IOTs has logical RowIDs. Logical RowIDs allow the construction of secondary indexes and improve index performance allowing the IOT performance...