{"id":495,"date":"2024-08-30T01:30:42","date_gmt":"2024-08-30T01:30:42","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=495"},"modified":"2025-06-02T10:45:40","modified_gmt":"2025-06-02T10:45:40","slug":"index","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/index\/","title":{"rendered":"INDEX"},"content":{"rendered":"\n

SQL INDEX Keyword<\/h2>\n\n\n\n

The INDEX keyword is used to create indexes on one or more columns of a table to improve the performance of data retrieval. Indexes help speed up queries, especially on large datasets.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL INDEX Syntax<\/h2>\n\n\n\n
CREATE INDEX index_name\nON table_name (column1, column2, ...);<\/pre><\/div>\n\n\n\n
DROP INDEX index_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL INDEX Create an Index on a Column Example<\/h2>\n\n\n\n
CREATE INDEX idx_last_name\nON Patients (last_name);<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL INDEX Create an Index on Multiple Columns<\/h2>\n\n\n\n
CREATE INDEX idx_name_gender\nON Patients (first_name, gender);<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL INDEX Drop an Index Example<\/h2>\n\n\n\n
DROP INDEX idx_last_name;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL INDEX Labs<\/h2>\n\n\n\n