Category Archives: interview

10 Oracle Hints to the Database


Oracle SQL performance tuning. using Hints in the database query

Advertisements

06 Index Suppression


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

02 Oracle Optimizer and its execution plan


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

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,