An index can be created in one or more columns. IF the number of columns included in an index is greater than one it’s known as a: Composite index
An index created on multiple table data columns is called a composite index as shown in Diagram 1.
The following is the syntax for creating composite index.
<System prompt> CREATE INDEX <IndexName> ON <Table Name> (<Column Name1>, <Column Name2>);
mysql> CREATE INDEX product_id ON productdetail (Serial_NO, ID);
What keeps you awake at night?
Do let us know.
We will try our best to deliver tutorials that will help you sleep much better.
By Ivan Bayross Cost USD 4.50/- only
160 pages packed with immediately usable information
Freebies worth 250 USD/- come with this purchase