Hi everyone,
– Index –
CREATE INDEX Siparisler
ON Test2
(cariHesapKodu
,tarih DESC
) WHERE (fisNo
is not null) WITH({“index_type” : “forestdb”})
But query not working or query result not coming.
Select * From Test2 Where fisNo IS NOT NULL AND cariHesapKodu="" ORDER BY tarih DESC LIMIT 20 OFFSET 0