select * from bucket1 where key1=‘xy’;
Is the below covering index for above query ok:
create index idx1 on bucket1(
*) where key1=‘xy’;
Is this normal, I am specifically referring to the asterisk which denotes “all keys”. I dont think it is right. When I EXPLAIN, it does not use this index.