Sample Header Ad - 728x90

EXPLAIN SQL does not use the index in GridDB

2 votes
0 answers
14 views
I have created an index, but explain sql does not use the index. I have ensured that GridDB has up-to-date statistics by running the available commands and index on (DeviceId, Property) is in the correct order. griddb 5.1.0 gs[public]> explain analyze select * from properties_test where deviceId='101' and property='0' limit 0,10; The query had been executed. (60,662 ms) gs[public]> getplantxt Id Type Input Rows Lead time Actual time Node And more.. --------------------------------------------------------------------------------------------------- 0 SCAN - - 60597 48739 192.168.1.62:10001 table: {properties_test} LIMIT: 10 1 RESULT 0 10 0 0 192.168.1.62:20001 gs[public]> showcontainer properties_test Database : public Name : properties_test Type : COLLECTION Partition ID: 13 DataAffinity: - Columns: No Name Type CSTR RowKey ------------------------------------------------------------------------------ 0 Type STRING 1 DeviceId STRING 2 Property STRING 3 Id STRING 4 NumberValue DOUBLE 5 Value STRING 6 CreateTime TIMESTAMP 7 Timestamp TIMESTAMP Indexes: Name : Type : TREE Columns: No Name -------------------------- 0 Property Name : Type : TREE Columns: No Name -------------------------- 0 DeviceId Name : Type : TREE Columns: No Name -------------------------- 0 Timestamp Name : Type : TREE Columns: No Name -------------------------- 0 DeviceId 1 Property
Asked by Arqish Mithani (49 rep)
Aug 13, 2024, 06:35 AM