Using Table Index

If table has primary key than no need of creation of index for that table

For 100 rows may be no need to use the index. If a table having huge number of records with table fields also having more, that time indexing is needed to execute the query fast and reliable.

Index is needed when data volumes increases. For less records, index is not required. Indexes enables the database retrieve and present to the end-user with ease.

Index is a database structure which stores column value in order and pointer to the row containing this value.During query execution index is used to fast search column data used in where condition.

If table has less no of columns but one primary key then no need of index. Clustered index is automatically created for primary key.

If table has less no of columns and no primary key then index is needed.

If table has more no. of columns then index is needed.

Please let me know if any further doubt.

Thanks.

Hi,

Index is used to speed up query.

If particular column is used often in queries and table has lot of data.Then it is recommended to create index for that column of the table. It will speed up the query.

If you create primary key clustered index is automatically created on that column.


If you need any further assistance or discussion please mail me at altafhsayyed@yahoo.com

Thanks and regards