I suppose you named a perfect example of a "COTS system" that was designed and written when the RBO ruled. :-) Goulet, Dick wrote: > Wolfgang, > > That's probably an absolute truth. But I can guarantee you that > it rules when working with the data dictionary. > > -----Original Message----- > > Could that be that many systems, especially in COTS, were designed and > written at a time when the RBO "ruled" and therefore the design and the > sql are tuned around the RBO? > -- Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l