when I run a SQL query with the two indexes, but ignite does not perform as
expected, it only uses dpId does not use devId, I explain the SQL:
SELECT
__Z0.ID AS __C0_0,
__Z0.GMTCREATE AS __C0_1,
__Z0.GMTMODIFIED AS __C0_2,
__Z0.DEVID AS __C0_3,
__Z0.DPID AS __C0_4,
__Z0.CODE AS __C0_5,
__Z0.NAME AS __C0_6,
__Z0.CUSTOMNAME AS __C0_7,
__Z0.MODE AS __C0_8,
__Z0.TYPE AS __C0_9,
__Z0.VALUE AS __C0_10,
__Z0.RAWVALUE AS __C0_11,
__Z0.TIME AS __C0_12,
__Z0.STATUS AS __C0_13,
__Z0.UUID AS __C0_14
FROM "data_point".T_DATA_POINT __Z0
/* "data_point".IDX_DPID: DPID = 1 */
WHERE (__Z0.DEVID = '00200008005459000a70')
AND (__Z0.DPID = 1)
When I only use devId as query condition:
SELECT
__Z0.ID AS __C0_0,
__Z0.GMTCREATE AS __C0_1,
__Z0.GMTMODIFIED AS __C0_2,
__Z0.DEVID AS __C0_3,
__Z0.DPID AS __C0_4,
__Z0.CODE AS __C0_5,
__Z0.NAME AS __C0_6,
__Z0.CUSTOMNAME AS __C0_7,
__Z0.MODE AS __C0_8,
__Z0.TYPE AS __C0_9,
__Z0.VALUE AS __C0_10,
__Z0.RAWVALUE AS __C0_11,
__Z0.TIME AS __C0_12,
__Z0.STATUS AS __C0_13,
__Z0.UUID AS __C0_14
FROM "data_point".T_DATA_POINT __Z0
/* "data_point".IDX_DEVID: DEVID = '00200008005459000a70' */
WHERE __Z0.DEVID = '00200008005459000a70'
It is very strange, so can anyone tell me how to use devId and dpId as query
index?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
