Today I have multiple views in order to use they ability to filter and sort, for example if I have employee object the I have several views for it:
This view are used mainly for filtering and sorting. Now that I can do that in n1ql pretty easy by select queries, should I create multiple indexes like the views:
- create index on employee(id)
- create index on employee(address)
- create index on employee(name)
for better performance or one index on employee would be enough?