Skip to Content
0
Former Member
May 25, 2009 at 04:14 AM

SQL and Index

9 Views

Hi all,

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.

Rgds,

Simple