We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. Databases
  3. Indexes
  4. Indexes - 4

Indexes - 4

The correct syntax for creating composite indexes in MS SQL Sever is:

<p>CREATE INDEX index_name</p> <p>ON table_name(column1), table_name(column2);</p>
<p>CREATE INDEX index_name</p> <p>ON table_name(column1) and table_name(column2);</p>
<p>CREATE INDEX index_name</p> <p>ON table_name(column1, column2);</p>
<p>All the above-mentioned syntax are correct.</p>