Category Archives: sql

SQL – Show Indexes Table of content The SQL Show Index Statement The SHOW INDEX is the basic SQL statement to retrieve the information about the indexes that have been defined on a table. However, the SHOW INDEX statement only works on MySQL RDBMS and is not a valid statement in the SQL Server. To […]

SQL – Clustered Index Table of content An index in a database is a data structure that helps to improve the speed of retrieving specific data from tables and views. Data in a table is stored in the form of an unordered data structure called a “Heap”, where rows are placed without any specific order. […]

SQL – Full Join Table of content The SQL Full Join SQL Full Join creates a new table by joining two tables as a whole. The joined table contains all records from both the tables and fills NULL values for missing matches on either side. In short, full join is a type of outer join […]