Hi Guys,
I am creating index on 70G.B table the index is approx
4g.b and it is taking a long time.
Any ideas to speed it up.
Thx
Cameron
Printable View
Hi Guys,
I am creating index on 70G.B table the index is approx
4g.b and it is taking a long time.
Any ideas to speed it up.
Thx
Cameron
Use the "nologging" clause with the parallel clause as well.
Use nologgin and Parallel.
Also why don't u partition the Table, if possible , to make ur administration job easier.
Thx