Technical Blog

  Less Overhead on Unindexed Foreign Keys    A table level share lock is placed on unindexed foreign keys in a child table when doing an ...

RAID 2 Data is distributed in extremely small increments across all disks and adds one or more disks that contain a Hamming code for redun...

RAID an acronym for Redundant Array of Inexpensive Disks or Redundant Array of Independent Disks, is a technology that allows high levels o...

Two types of Locking In Optimistic locking the row will not be locked until the actual update is performed. In order to prevent the los...

Syntax: WIDTH_BUCKET(column-name/expr, low/min,high/max,bucket_count) ; Divide a set o data into buckets (ie: partition ) with an equal ...