Databases Reference
In-Depth Information
3.
Populate the table with data:
INSERT INTO IOT_COUNTRIES SELECT * FROM COUNTRIES;
4.
Execute a query to the original (heap) table:
SET AUTOT TRACE EXP STAT
SELECT
COUNTRY_ID, COUNTRY_NAME
FROM COUNTRIES
WHERE COUNTRY_ID = 52770;
5.
In the next screenshot, we can see the execution plan and statistics for the query
on the original table:
6.
Execute the same query to the table (index organized ) we just created:
SELECT
COUNTRY_ID, COUNTRY_NAME
FROM IOT_COUNTRIES
WHERE COUNTRY_ID = 52770;
