Re: FGAC and that 30%

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 16 Jul 2004 18:12:29 -0700
Message-ID: <1090026769.189614@yasure>

Hans Forbrich wrote:

> robert wrote:
>
>

>>did you ever find out where that 30% went?  was it lack of indexing,
>>or actual function execution? a bit of both?
>>

>
>
> One other possibility comes to mind - additional complexity.
>
> A lot of people assume FGAC is a rewrite to select from an additional
> column, as in "where permission = 'Top Secret'". FGAC is not limited to
> that and can involve significant additional overhead if one is not careful.
> For example, you could use a list (IN,LIKE or BETWEEN processing), or base
> the selection on calculations.
>
> /Hans

Good point. My usages have all been 'trivial' additions to the WHERE clause.

Daniel Morgan Received on Fri Jul 16 2004 - 20:12:29 CDT