SQL index creation taking an abnormally long time
Posted on 2016-11-15
I'm trying to create a nonclustered index on a SQL table, and it's taking what I would consider an extremely long time.
The table has approximately 120K rows, and already has a single index on a unique key column.
I'm trying to CREATE NONCLUSTERED INDEX _index_klltilrm_h_UPC ON KLLTILRM_H (UPC_CODE)
The UPC_CODE column is a char(12) data type.
SQL Server 2012, running on a Server 2012 environment with 128GB ram - the data lives on a brand new EqualLogic 16-drive SAN that is (for the moment) dedicated to the DB server.
Anyone have any ideas how to solve this one?