Is it required to use Index when the MySQL table has only 100 rows? Justify your answer?
By Arun Desai
Hi sir,
Can you explain whether i need to use a index if mysql table has only 100 rows
Teacher SiliconIndia replied to Arun Desai Monday, November 23, 2009
Hi Arun Desai,
If a table contains only 100 rows, you may not 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
