Home » SQL & PL/SQL » SQL & PL/SQL » Partitioning and Optimizer Mode
Partitioning and Optimizer Mode [message #18532] Mon, 04 February 2002 13:39 Go to next message
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.

Re: Partitioning and Optimizer Mode [message #18534 is a reply to message #18532] Mon, 04 February 2002 16:46 Go to previous message
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.
Previous Topic: flattening an event table
Next Topic: query
Goto Forum:

Current Time: Tue Sep 28 00:04:24 CDT 2021