urgent

[julian]

Originally posted by m00nminkey

You need to be careful playing with indexes using the RB0 (Rule based) as you effect the database performance!

m00n

Why using RBO? It's like running a Mercedes Benz with a Trabant engine :-)

And you might not have heard but there will be no RBO in 10i.

[tamilselvan]

Since 1991 in every release Oracle has been saying that RBO would not be supported, but Oracle kernel developers and designers do not know how to rewrite their own code to utilize the CBO features. That is why they still supported RBO. I do not think RBO will be totally eliminated in 10i.

[julian]

Originally posted by tamilselvan
Since 1991 in every release Oracle has been saying that RBO would not be supported, but Oracle kernel developers and designers do not know how to rewrite their own code to utilize the CBO features. That is why they still supported RBO. I do not think RBO will be totally eliminated in 10i.

Read 189702.1: Rule Based Optimizer is to be Desupported in Oracle10i.