Technical Blog

         Partitioning addresses key issues in supporting very large tables and indexes by splitting them into smaller and more manageable ...

CREATE TABLE my_table AS SELECT * FROM my_other_table The best thing about CTAS is that it does not use rollback segments . The above q...

The rightmost uppermost operation of an explain plan is the first thing that the explain plan will execute. Read Right-Left and Top-Down ...

Oracle Trace    Explain plan provides an approximation of the cost of an individual SQL statement . It doesn’t always correspond to what ...

BEGIN    INSERT INTO MY_DATA  VALUES (1, 'STEVEN');    INSERT INTO MY_DATA  VALUES (2, 'VEVA');    INSERT INTO MY_DATA VAL...