Category Archives: sql

SQL – Alternate Key Table of content The SQL Alternate Key SQL Alternate Keys in a database table are candidate keys that are not currently selected as a primary key. They can be used to uniquely identify a tuple(or a record) in a table. There is no specific query or syntax to set the alternate […]

SQL – Indexes Table of content The SQL Indexes SQL Indexes are special lookup tables that are used to speed up the process of data retrieval. They hold pointers that refer to the data stored in a database, which makes it easier to locate the required data records in a database table. SQL Indexes work […]

SQL – Create Index Table of content An index is an effective way to quickly retrieve data from an SQL database. It is a database object that references the data stored in a table, which significantly improves query and application performance of a database. The process of indexing in SQL is similar to that of […]