![SQL SERVER – How to create a nonclustered index within the create table statement | SQL Server Portal SQL SERVER – How to create a nonclustered index within the create table statement | SQL Server Portal](https://raresql.files.wordpress.com/2015/01/how-to-create-a-nonclustered-index-within-the-create-table-1-1.png)
SQL SERVER – How to create a nonclustered index within the create table statement | SQL Server Portal
![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ignoredup1.jpg)
SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave
![SQL SERVER - Optimize Key Lookup by Creating Index with Include Columns - SQL Authority with Pinal Dave SQL SERVER - Optimize Key Lookup by Creating Index with Include Columns - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2018/11/keylookup1.jpg)
SQL SERVER - Optimize Key Lookup by Creating Index with Include Columns - SQL Authority with Pinal Dave
![The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes. The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes.](https://use-the-index-luke.com/static/fig05_02_index_on_heap_table.x1.Zxzjx7lW.png)