May 19, 2023 at 12:50 pm
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
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply