Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Sensitive result sets & filters
Fri, Jul 2 2010 11:00 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

If I create a sensitive result set and then apply a filter is the filter applied to the whole dataset or just that portion that forms the result of the sensitive query?

The columns on which I'll be filtering will NOT be indexed.

I hope the question makes sense.

Roy Lambert
Sat, Jul 3 2010 10:32 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< If I create a sensitive result set and then apply a filter is the filter
applied to the whole dataset or just that portion that forms the result of
the sensitive query?

The columns on which I'll be filtering will NOT be indexed. >>

EDB classifies filters by their optimization status, and always executes
un-optimized filters against the sub-set of rows generated by the more
optimized filters that precede them.

--
Tim Young
Elevate Software
www.elevatesoft.com
Sat, Jul 3 2010 11:48 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>EDB classifies filters by their optimization status, and always executes
>un-optimized filters against the sub-set of rows generated by the more
>optimized filters that precede them.

Thanks

Roy Lambert
Image