What is the use of indexing table?

Answer Posted / aaina

to speed up the retrieval of data from mysql table

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default port for MySQL Server?

570


What is delimiter $$?

494


How do we use % when performing a search query?

518


How do I rename a table in mysql?

489


Is mysql free software?

491






How can we find out which auto increment was assigned on Last insert?

618


What is a trigger? How you can create a trigger in mysql?

481


How do I create a schema in mysql?

465


Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

463


Does mysql use tcp or udp?

519


What are the differences between char and varchar data types?

490


What is auto increment in mysql?

493


What is mysql used for?

514


How do I optimize a selected query in mysql?

500


Is mysql from oracle?

492