Category Archives: Verbat

12 Oracle Design Consideration


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

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

05 Simple Tuning Rules


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

02 Oracle Optimizer and its execution plan


Oracle Optimizer and its execution plan, cost based optimizer, execution plan. statistics, SQL tuning tools

09 Oracle SQL Tuning for Join Methods


Oracle SQL Tuning for Join Methods, Nested Loop Join, Sort Merge Join, Hash Join

MongoDB Indexing Part 3


Multi Term Query, Drop Index, Nested Fields, Indexing on an array, Unique Index, Compound indexes, Covering Index, Dead Weight Index, Background built Index,

MongoDB Indexing Part 2


Multi Term Query, Drop Index, Nested Fields, Indexing on an array, Unique Index, Compound indexes, Covering Index, Dead Weight Index, Background built Index,