October 26, 2010 at 1:56 pm
For example, we have two indexes needed to build.
We can create these two indexes sequentially.
We can also create these two indexes at the same time.
Which approach is faster?
Any input will be greatly appreciated.
October 26, 2010 at 2:40 pm
The answer really is 'it depends'. It depends upon what else is running at the time, how many CPU's you have, how much memory, what your IO subsystem is capable of, etc...
You could easily cause the system to hang while two indexes are being rebuilt - or, they may run in parallel with no issues.
The only way you are going to know for sure is to test both approaches.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 26, 2010 at 2:49 pm
SQL ORACLE (10/26/2010)
For example, we have two indexes needed to build.We can create these two indexes sequentially.
We can also create these two indexes at the same time.
Which approach is faster?
Any input will be greatly appreciated.
How about a third option?
...WITH SORT_IN_TEMPDB option should positively affect index creation performance - provided user database datafiles and tempdb datafiles are in different drives.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 26, 2010 at 4:47 pm
If you have a test system, I'd run a test. Try it both ways and see the time involved.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply