For last few days I was busy packing my things plus doing some important task related to my Australia trip but at last got time to write about something new in Oracle 11g called Virtual Columns. First lets go through one situation, we have a sales table with Gross_Amount and Discount_Amount. Now Net_Amount := Gross_Amount [...]
Entries Tagged as 'Virtual Objects in Oracle'
Understanding Virtual Columns
October 13th, 2007 · 1 Comment
Tags: Oracle 11g New Features · Oracle Administration · Oracle Database · Virtual Objects in Oracle
SQL Tuning Tip::Virtual Index
August 12th, 2007 · No Comments
Recently I came across term called Virtual Index or some call it fake indexes. I will use term Virtual Index to refer these indexes. This type of indexes has been extensively used by most Oracle Tuning Tools in the market. You can say almost all the tools which promise to give “if then analyzes” on [...]