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 [...]

[Read more →]

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 [...]

[Read more →]