Category Archives: database

Pedophile Priests  Rewarded In Catholic ” Justice ” System..


 Click the link and prepare for a shock.  http://wp.me/p3NNQG-3iV 

Shard or be Shredded


“Bob: So, how do I query the database? IT guy: It’s not a database. It’s a Key-Value store. . . . You write a distributed map-reduce function in Erlang. Bob: Did you just tell me to go **** myself? IT guy: I believe I did, Bob.” —Fault Tolerance cartoon, @jrecursive, 2009 Prelude Relational databases have […]
Read More »

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

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,