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.
