Forum : Is it required to use Index when the MySQL table has only 100 rows? Justify your answer?
Brief description about Online courses   join in Online courses
Home News Viewpoint
Travel Entertainment Auto Gadgets & Electronics Sports Lifestyle Food
Rankings Whitepapers Blogs Conferences About Us
View Arun Desai 's Profile

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

Hi sir,

Can you explain whether i need to use a index if mysql table has only 100 rows
Asked by Arun Desai | Nov 23, 2009 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
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
Nov 23, 2009

Forum By Category