Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?

Status
Not open for further replies.
usr1234

usr1234

Technical User
Sep 22, 2020
1
RO
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
it is about a big table, with many deleted records
thanks!
 
Status
Not open for further replies.

Similar threads

pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
126
pratimsingha
pratimsingha
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
148
evr72
evr72
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
171
fredericofonseca
fredericofonseca
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
98
Rohit K Gupta
Rohit K Gupta
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
96
handle907
handle907

Part and Inventory Search

Sponsor

Back
Top