How to know what is better a Px plan or wht other will be better?
Hi experts.
Database version 11.2.0.3
Table was created using degree 4. It's indexes by the way where created with Degree=1.
Someone told me this, and I don't know what is better or what the other option will be if the table where of degree1.
Under MANUAL having DEGREE > 1 will allow the CBO to consider PX plans for those SQLs accessing those tables, you may want to double check if that is what you want.
This was the Observations in the Sqlt report for a query mentioned on the Ashrpt report - in the Top SQL with Top Events
Database version 11.2.0.3
Table was created using degree 4. It's indexes by the way where created with Degree=1.
Someone told me this, and I don't know what is better or what the other option will be if the table where of degree1.
Under MANUAL having DEGREE > 1 will allow the CBO to consider PX plans for those SQLs accessing those tables, you may want to double check if that is what you want.
This was the Observations in the Sqlt report for a query mentioned on the Ashrpt report - in the Top SQL with Top Events
0