The default display of Explain Plan in TOAD SQL Editor has very basic information. Right-clicking on the explain plan and selecting “Adjust Content” from the context menu will bring “Execution Plan Preferences” window, which allows you to control the information displayed in the Explain Plan tab.
Access paths are ways in which data is retrieved from the database. In general, index access paths should be used for statements that retrieve a small subset of table rows, while full scans are more efficient when accessing a large portion of the table. Online transaction processing (OLTP) applications, which consist of short-running SQL statements …
CREATE TABLE has lot of options to go with it; it is hard to remember all of them. Most people will get lost while reading the rail road diagrams. It is fairly quick to create the table in its simple form and obtain all the parameters associated with it. Once the table is created in …
Get a complete CREATE TABLE definition using DBMS_METADATA package Read More »