Details
-
Improvement
-
Resolution: Unresolved
-
Minor
-
CBAS DP3
-
Build: 5.0.0-665
Description
Run the below statements:
create bucket beer_sample with {"name":"beer-sample"};
|
create shadow dataset beer_ds on beer_sample;
|
create index idx_city on beer_ds(geo.lat:double,city:string);
|
select * from Metadata.`Index` where DatasetName='beer_ds' and IsPrimary=False
|
connect bucket beer_sample
|
SELECT count(*) FROM `beer_ds` where geo.lat=49.7652 or city='San Francisco';
|
EXPLAIN SELECT count(*) FROM `beer_ds` where geo.lat=49.7652 or city='San Francisco';
|
When you examine the last query above, observe that it is referring to data_scan instead on index_scan.