How to tune something doing nothing?

To end this year in glory, I tried to replace a row-level trigger (LSC_TR1) into a statement level trigger (LSC_TR2) SQL> create global temporary table lsc_t1(x number primary key) 2 on commit delete rows; Table created. SQL> create table lsc_t2(x number primary key); Table created. SQL> create table lsc_t3(x number primary key); Table created. SQL> […]

HOT

CREATE TABLE T(X NUMBER PRIMARY KEY) ORGANIZATION HEAP; I have read the SQL reference more than once -believe me- but I did not notice this syntax until today… an HOT table is a simple table and this clause is optional. An IOT, or INDEX ORGANIZED TABLE, is a table where you mostly select thru an […]