Best practice for index in query

SQL++
1

If I create an index for a N1QL query, do I need to index all fields that I want to return or only the one used in the where clause for best performance ?

2

Check this out https://blog.couchbase.com/create-right-index-get-right-performance/