Using Table Index

Is it required to use Index when the MySQL table has only 100 rows? Justify your answer

Questions by nagaphp_indore

Showing Answers 1 - 11 of 11 Answers

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.

  Was this answer useful?  Yes

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions