Re: Oracle 11g Virtual Columns?

From: <ivl5_at_hotmail.com>
Date: Tue, 20 Jan 2009 14:01:52 -0800 (PST)
Message-ID: <0688e6cb-cea0-4391-b583-007002c6aadd_at_q30g2000prq.googlegroups.com>

On Jan 19, 11:20 pm, Connor McDonald <connor_mcdon..._at_yahoo.com> wrote:
> zigzag..._at_yahoo.com wrote:
>
> > I have read various articles on virtual columns? I still do not
> > understand their advantages other than they save some disk space, One
> > can put logic of virtual columns in a trigger which will save
> > information in a real column. Real column will need some additional
> > disk space, but it will save some cpu time when one is doing slelects
> > on “virtual” columns.
>
> Well, they're columns...so lots of goodies just in that, eg constraints
> (foreign key, not null, unique, primary key), optimizer stats, fgac, etc
> etc

... and don't forget you can partition based on virtual columns - could be very handy.

Igor

> --
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> Co-author: "Oracle Insight - Tales of the OakTable"
>
> web:http://www.oracledba.co.uk
> web:http://www.oaktable.net
> email: connor_mcdon..._at_yahoo.com
>
> "Semper in excremento, sole profundum qui variat."
>
> ------------------------------------------------------------
Received on Tue Jan 20 2009 - 16:01:52 CST