Good Day All,
What all factors determines the speed of the index creation .
I have seen 100 million row table -→ index creation on 3 columns -→ taken nearly 1 hours
Also seen 360 million row table-→ index creation on 3 columns -→ completed in 15 mins
Both cases no parallel was used , table degree was 1 ,the CPU was 32 and the column on table where having equal rows as table ie nothing were empty or null
So what factors determines the speed other than the obvious reasons such cpu /hw ,row count
Is there more to the table properties? like type of the data or lenght of the data /rows?
Kindly advise as it would be helpful