Tag: databases

Avoid full table scan

Avoid index scan

Avoid network traffic

Avoid cartesian join

Columns that contains values with less variation in the number of duplicates

Columns that contains values with large variation in the number of duplicates

Columns that contains values with no variation in the number of duplicates

Columns that contains values with ZERO variation in the number of duplicates

Exp

Imp

Explain Plan

vi Editor

The more heavily indented an access path is, the earlier it is executed

The more heavily indented an access path is, the later it is executed

If two steps are indented at the same level, the uppermost statement is executed first

If two steps are indented at the same level, the uppermost statement is executed last

Right to Left processing of Source (Tables, views etc.) by Parser

Left to Right processing of Source (Tables, views etc.) by Parser

Bottom to Up processing of WHERE condition clauses

Up to Bottom processing of WHERE condition clauses

Using NULL / NOT NULL on indexed columns won’t use INDEX

Using NULL / NOT NULL on indexed columns gives ERROR

Using NULL / NOT NULL on indexed columns disables INDEX

Using NULL / NOT NULL on indexed columns makes the INDEX unusable

True

False

Automated Database Deployment Monitor

Automated Database Development Monitor

Automated Database Diagnostic Monitor

Automated Database Distributed Monitor

Equi Join

Outer Join

Non-Equi Join

Cartesian Join