title: Why does the creation of an index take a long time?
body: <p>I am using SQL Server 2008.</p>
  
  <p>i am creating an NON CLUSTERED index on a table in my database.</p>
  
  <p>What I see while creating that index is that the query is taking a lot of time; in my case now 8-9 mins is done but still create index query is running.</p>
  
  <p>Can somebody help me to get why it is so ?</p>