[V4RB] Snail speed

[Ruslan Zasukhin]

On 5/5/06 11:41 PM, "Russ Tyndall" <fitzbew at nc.rr.com> wrote:

> 
> Ruslan, Stan:
> 
> "EXPLAIN" is going to be great.

Btw, this is how it looks now for query

SELECT *
FROM T1
WHERE f1 = 1 AND f2 > 4


----------------------------------------------------------------------------
-------------------------
object = Predicate [AND] : USE INDEX = FALSE : TIME = 0 : ROWS = 2

   ACTION = Proceed Indexed Operands : USE INDEX = FALSE : TIME = 0 : ROWS =
4
    object = Field [f1] : ACTION = FindValue(1) : USE INDEX = TRUE : TIME =
0 : ROWS = 4

  ACTION = Proceed Non-Indexed Operands : USE INDEX = FALSE : TIME = 0 :
ROWS = 2
    object = Field [f2] : ACTION = FindRange (4, +inf) : USE INDEX = FALSE :
TIME = 0 : ROWS = 2

----------------------------------------------------------------------------
-------------------------

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]