Major Description
create index ix1 on default(type); |
create index ix2 on default(x,y,z) WHERE type = "abc"; |
explain select * from default where type = "abc" AND x = 5; |
Avoid using IntersectScan of ix1 and ix2 and use just ix2
Attachments
Issue Links
- mentioned in
-
Page Loading...