Details
-
Improvement
-
Resolution: Won't Do
-
Major
-
None
-
None
Description
N1QL has been around for a long time, but postings in the Forums and on Stack Overflow suggest that new users still get confused by "Primary" indexes, and the fact that they're not supposed to use them. This is probably because "Primary" keys are a good thing in the relational world, often the fasted way to reach a document.
I suggest renaming "Primary" indexes to "Full_Scan" indexes, so the name would imply the cost they entail.