I’ve created an index like this:
*** create index byName on user(name,family)
How can I write a query which uses that index to retrieve my result?
– select * from user where name=‘afshin’ and family=‘afzali’
What are the rules that I have to follow to be able to use my intended indexes?