add documents on creating/using indexes on meta().id

Subject: Re: META().id

Prasad,

If you are planning to document, You should also consider Primary Covering Scan.

https://issues.couchbase.com/browse/MB-19443
SELECT META().id FROM xxx => use primary index as covering index, skip Fetch.
DELETE FROM xxx => use primary index as covering index, skip Fetch.
Regards,
Sitaram

From: Cihan Biyikoglu <cihan@couchbase.com>
Date: Friday, May 6, 2016 at 11:01 AM
To: Gerald Sangudi <Gerald@couchbase.com>
Cc: Keshav Murthy <keshav@couchbase.com>, Prasad Varakur <prasad.varakur@couchbase.com>, Sitaram Vemulapalli <sitaram.vemulapalli@couchbase.com>, Prerna Manaktala <Prerna.Manaktala@couchbase.com>
Subject: RE: META().id

This is great. Is there an improvement open for this? I missed this but hopefully Prasad caught it and we are documenting all these enhancements.
Thanks
-cihan.

From: Gerald Sangudi
Sent: Friday, May 6, 2016 9:27 AM
To: Cihan Biyikoglu <cihan@couchbase.com>
Cc: Keshav Murthy <keshav@couchbase.com>; Prasad Varakur <prasad.varakur@couchbase.com>; Sitaram Vemulapalli <Sitaram.Vemulapalli@couchbase.com>; Prerna Manaktala <Prerna.Manaktala@couchbase.com>
Subject: META().id

Cihan,

I know you had some personal interest in this:

On the latest build on master, you can now CREATE INDEX with META() in all the following forms, and they are all equivalent:

CREATE INDEX idx ON default( META().id );

CREATE INDEX idx ON default ( META(default).id );

CREATE INDEX idx ON default ( META(self).id );

All of these indexes are used equivalently with the appropriate queries.

Gerald