hey dude , wheres my car ?
RBO = rule based optimizer.
(not recomended to be used)
CBO = cost based optimizer.
(u have to use the analyze table command, to fill up the statistics table .... so that this optimizer mode can be used)
(u can specify that cbo be used , both at command line and in init file).
---------------------------------------------------------------------
please check the performance after creation of indexes on the join column ! this may improve u'r performance a lot or in the wrong conditions , may degrade the performance .
normally indexes should be used more where the tables participate in a DSS (decission support) type application !
---------------------------------------------------------------------
say dude , where's my car ?
hope this note helps u !
cheers