Performance Tuning and AccessType
Posted: Tue Nov 09, 2010 3:55 pm
Hi,
My query takes a longtime and I tried to view the plan_table to check ffor the accessstype. And please find the result of my query below.
"Code'd"
My query is
1) There are few tables where MATCHCOLS = 0. Can this decrease performance?
2) If not please let me know if there is any other area to improve this by looking at the plan_table results.
3) Is it possible to find the exact column of the table wich goes for scanning from the plan_table ?
Thanks,
M
My query takes a longtime and I tried to view the plan_table to check ffor the accessstype. And please find the result of my query below.
ACCESSTYPE MATCHCOLS INDEXONLY ACCESSNAME
+--------- --------+ -------+- -+--------
0 N
I 1 N B
M 0 N
MX 1 Y C3
MX 1 Y C3
I 0 N E1
I 1 N F1
I 2 N F5
MI 0 N
MU 0 N
MX 1 Y C3
MX 1 Y C3
MU 0 N
+--------- --------+ -------+- -+--------
0 N
I 1 N B
M 0 N
MX 1 Y C3
MX 1 Y C3
I 0 N E1
I 1 N F1
I 2 N F5
MI 0 N
MU 0 N
MX 1 Y C3
MX 1 Y C3
MU 0 N
My query is
1) There are few tables where MATCHCOLS = 0. Can this decrease performance?
2) If not please let me know if there is any other area to improve this by looking at the plan_table results.
3) Is it possible to find the exact column of the table wich goes for scanning from the plan_table ?
Thanks,
M