Forum Discussion
Synapse SQL - Index creation is extremely slow for a small table
I attempted to create a nonclustered index on a small table in synapse. It was running for was running 15 mins and started to block sessions, so I cancelled it. The FACT_NON_MERCH_DISCOUNT table ha...
Can you tell me what could be causing a small new index to run so long?
DDL commands like creating an index requires exclusive access on the table; so may the table is in use and this blocks your index creation.