vishnu2004k

 Profile Answers by vishnu2004k 

• May 13th, 2009

 

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

krr_r25

 Profile Answers by krr_r25 Questions by krr_r25

• May 29th, 2009

 

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.

sanasunny

 Profile Answers by sanasunny Questions by sanasunny

• May 30th, 2010

 

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.

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

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.

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

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