I have a schema that *loves* views ... they have a view that is a join of 4 views which individually are joins of views and tables. Can you see optimizer going nuts.... so when we tested CBO, this schema owner exclaimed 'CBO doesn't work!', so we were back to using RBO.
I have finally convinced them to stop creating a 'create view v_tablename as select * from tablename' ... that was my first step. So, I have nothing against views, but only when used in moderation. Cheers Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
*******************************************************************************1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *******************************************************************************1
