Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FBI or Shadow column?

Re: FBI or Shadow column?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 14 Jul 2005 21:07:08 +0200
Message-ID: <db6cph$obt$3@news1.zwoll1.ov.home.nl>


Holger Baer wrote:
>
> The advantages of FBI:
>
> - You save a little space
> - You don't need to know that there exists a shadow column, so writing
> efficient ad hoc queries is more likely to happen
> - you don't need some trigger mimic to make sure that the column is
> properly
> populated which leads to less code to worry about
>
> disadvantages:
>
> None that I'd loose sleep about
>

Another way of looking at it :)

-- 
Regards,
Frank van Bortel
Received on Thu Jul 14 2005 - 14:07:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US