Category Archives: Technology

08 Considerations while using PLSQL in programming (Oracle)


Considerations while using PLSQL in programming (Oracle)

07 Performance Improvement Consideration


Oracle Performance Improvement Consideration, union vs OR, Union all vs Union, exist vs IN

06 Index Suppression


Index Suppression in Oracle, operators, sub-strings, Arithmetic operators, Truncate , function based index

05 Simple Tuning Rules


Simple Tuning Rules for Oracle. Where vs having, table aliases

04 Explain Plan


Oracle Explain Plan, Execution Plan,