Magician, Founder of indianmagicians.com n worldofmagicians.com , TV star, Software Engineer, Wikipedian, Actor, Skit Artist, Mimic Artist n lots..

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and the use of more storage space. Indexes can be created using one or more  [ Read More ]

Visual Explanation of SQL Joins

An SQL join clause combines records from two or more tables in a database. ANSI standard SQL specifies four types of JOINs: INNER, OUTER, LEFT, and RIGHT. Since SQL joins appear to be set-based, its easy to explain using Venn  [ Read More ]