Data Warehousing Fresh views on refresh views So, you have got those MV in place and now need to keep them up to date, well there are three options: do-it-yourself, Complete refresh and 'Fast' refresh. To me, fast is not the right name, as under the covers all of the rows affected by data change
Data Warehousing Materialized views (revised.. but only a little!) In a recent blog reply Oracle Sponge Blog Squarepants [http://oraclesponge.blogspot.com/] (sorry David) mentioned not having much success with query rewrite on Materialized Views. Rashly I said I would blog something. These notes relate specifically to Oracle 9.2 in Data Warehouses. You will find changes with Oracle
Oracle Database Bind Variables Explained If you’ve been developing applications on Oracle for a while, you’ve no doubt come across the concept of ‘Bind Variables’. Bind variables are one of those Oracle concepts that experts such as Tom Kyte and Jonathan Lewis frequently cite as being key to application performance, but it’s
