Partitioning and Optimizer Mode [message #18532] |
Mon, 04 February 2002 13:39 |
Ronak Bhatt
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
1)Is it must to have cost based optimizer to use Table and Index partitioning in Oracle 8i ?
2) If not, is there any shortcoming of using RULE with partitioning.
thanks,
ronak
|
|
|
Re: Partitioning and Optimizer Mode [message #18534 is a reply to message #18532] |
Mon, 04 February 2002 16:46 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I haven't tried, but some thoughts anyway...
1.) No, Rule based will always work - it's what kicks in when there are no table/index stats etc. FTS probably would visit all partitions though unless you specified them in the query.
2.) seeing as partitioned tables are the largest, the penalty of choosing the wrong plan could result in more full table scans and other inefficient paths.
|
|
|