ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From javadevmtl <java.dev....@gmail.com>
Subject Explain the h2 explain
Date Thu, 10 Sep 2015 18:42:01 GMT
Using 1.3.0

So I ran the following query EXPLAIN SELECT FIELD1 FROM TRX WHERE FIELD2 = ?

And got.

{"result":"[[
SELECT\n
    FIELD1 AS __C0\n
    FROM \"cache\".TRX\n

    /* \"cache\".\"FIELD2_idx\": FIELD2 = ?1 */\n

    WHERE FIELD2 = ?1], [SELECT\n
    __C0 AS FIELD1\n
    FROM \"cache\".__Z0()\n

    /* function */]]"}

So does this mean that the cache is using the index?
What is the second select?
Is this an optimal query based on the explain result?





--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Explain-the-h2-explain-tp1344.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message