Collections:
Create an Index for a Given Table in MySQL
How To Create an Index for a Given Table in MySQL?
✍: FYIcenter.com
If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an index, you can use the "CREATE INDEX" statement as shown in the following script:
mysql> CREATE TABLE tip (id INTEGER PRIMARY KEY, subject VARCHAR(80) NOT NULL, description VARCHAR(256) NOT NULL, create_date DATE NULL); Query OK, 0 rows affected (0.08 sec) mysql> CREATE INDEX tip_subject ON tip(subject); Query OK, 0 rows affected (0.19 sec) Records: 0 Duplicates: 0 Warnings: 0
⇒ Show All Indexes of a given Table in MySQL
⇐ Drop an Existing Table in MySQL
2018-02-14, 1535🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...