Tag: databases

If parallelism is used in a DML then PX COORDINATOR should be below DML operation in the EXPLAIN PLAN ?

Comment lines contain about the parallelism used ?

BITMAP INDEX is used in situations where the index is created after the table or partition is populated ?

If we are using UNION or UNION ALL then comment is necessary ?

UNION or UNION ALL should be avoided ?

Reading and writing data in datawarehouse should be maximized ?

In case of any deployment you if we need to backup data anywhere there must be a clear plan to remove this later. ?

Make sure that every SQL that will run in your PL/SQL writes it’s elapsed time to your log file?