Stan's slow problem EXPLAIN

[Ruslan Zasukhin]

On 6/1/06 6:56 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

Btw, this is how looks EXPLAIN for Stan's query


FOR SQL QUERY TIME = 63 :
     DO SELECT : TIME = 63 : ROWS = 1
         DO SIMPLE SELECT : TIME = 63 : ROWS = 1
             DO Single Table Without GROUP BY : TIME = 63 : ROWS = 1
                FOR Table [tblTransactions]  DO resolve WHERE statement :
TIME = 63 : ROWS = 0
                    FOR Predicate [AND] TIME = 63 : ROWS = 0
                         DO AND Indexed operands : TIME = 63 : ROWS = 219
                            FOR Field [Transaction_Date]  DO FindRange
[01/01/2000 00:00:00:000, 12/31/2006 00:00:00:000] : TIME = 0 : ROWS = 38727
                            FOR Field [Transaction_Refunded]  DO
FindValue(1) : TIME = 25 : ROWS = 219
                            FOR Field [Transaction_ChargedBack]  DO
FindValue(0) : TIME = 38 : ROWS = 38684
                         DO AND Non-Indexed operands : TIME = 0 : ROWS = 0
                            FOR Predicate [OR] TIME = 0 : ROWS = 0
                                 DO OR Indexed operands : TIME = 0 : ROWS =
21
                                    FOR Field [Transaction_Country]  DO
FindLike : TIME = 0 : ROWS = 21
                                    FOR Field [Transaction_Country]  DO
FindLike : TIME = 0 : ROWS = 0


-- 
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]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20060601/fe0185af/attachment.html