i searched the forum but am still lost for the following.
1. If sql created with search criteria does not match the index created, will it cause performance to be slower?
2. May i know what are the things to take note when creating index for better performance?
3. How can i test and verify that my sql and index is created with better performance?
Thanks in advance.