Category Archives: Verbat

12 Oracle Design Consideration


Oracle Design Consideration, Index organized tables, partitioned tables, range partition, list partition, hash partition, composite partition

Advertisements

11 House Keeping in Oracle


House keeping in Oracle: invalid optimizer statistics, buffer gets, Disk Reads

10 Oracle Hints to the Database


Oracle SQL performance tuning. using Hints in the database query

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