Create index success but query not working

Couchbase Server
,
1

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

2

what does the EXPLAIN say.

EXPLAIN Select * From Test2 Where fisNo IS NOT NULL AND cariHesapKodu="" ORDER BY tarih DESC LIMIT 20 OFFSET 0

Source: Couchbase SDKs

1 Like
3

@househippo

Thank you, have a nice work.