Post reply

Creating multiple identical indexes

  • May 19, 2023 at 12:50 pm

    #4193028

    Hi

    I have a large table of 87 million rows that needs to have 3 identical non clustered indexes on it. Please don't ask  me why, I'm aware of how ridiculous it sounds.........

    The first index creates in 10 minutes, the seconds one took 13 hours. I'm doing this on a development server that nobody else it using. Sp_whoisactive showed no  blocking or significant waits.

    Any idea why the huge difference in create times or does anyone know a better way of creating identical non clustered indexes.

    Cheers

    Alex

  • May 19, 2023 at 1:28 pm

    #4193042

    That's very odd.  Could you provide the CREATE INDEX command you are using (naturally change names as needed to protect your actual object/column names).

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply