Author: Ed Leafe
Posted: 2002-09-13 at 09:36:44
On Friday, September 13, 2002, at 09:23 AM, White, Clark wrote:
> I have found a lot of interesting information on removing the
> deleted() index tags to improve performance on a network.
>
> Has anyone on the list ever tried using the NOOPTIMIZE clause to turn
> Rushmore off to increase performance? If so, does this help at all?
It could, if you have lots of poorly-designed indexes. But you simply
can't beat Rushmore for queries that are highly discriminate; e.g,
searching for a PK or even a last name.
___/
/
__/
/
____/
Ed Leafe