RBO in 10g [message #232986] |
Tue, 24 April 2007 06:28 |
atulrsingh
Messages: 55 Registered: November 2006 Location: Mumbai
|
Member |
|
|
Hi Experts,
Is it true Rule Based Optimizer is no longer supported in 10g ?
whats is the alterative for the same
Thnx
|
|
|
|
|
|
Re: RBO in 10g [message #233107 is a reply to message #232986] |
Tue, 24 April 2007 13:47 |
gintsp
Messages: 118 Registered: February 2007
|
Senior Member |
|
|
The alternative is CBO and particularly first_rows_n for an oltp app and all_rows for more datawarehousing app. Of course this is general suggestion and thing may differ for some cases.
Gints Plivna
http://www.gplivna.eu
|
|
|
Re: RBO in 10g [message #234846 is a reply to message #233107] |
Thu, 03 May 2007 05:36 |
sriram717
Messages: 48 Registered: February 2007 Location: UNITED KINGDOM
|
Member |
|
|
Even Oracle has not come out of RBO completely
Say for example if you do a 10046 trace while the database startsup , you could see many statements with rule hint.
say for example like
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
END OF STMT
|
|
|
Re: RBO in 10g [message #234856 is a reply to message #234846] |
Thu, 03 May 2007 06:02 |
|
Michel Cadot
Messages: 68704 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Is this not what my post clearly showed without having to "hack" internal query?
Regards
Michel
|
|
|