What is the use of indexing table?
Answers were Sorted based on User's Feedback
Answer / guest
fast searching and find
retrieving data becomes fast
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / aaina
to speed up the retrieval of data from mysql table
| Is This Answer Correct ? | 5 Yes | 2 No |
can you elaborate on blob and text in mysql? : Mysql dba
What is pragma exception?
How to return query output in xml format?
How many columns can a mysql table have?
ru compare the 2 null values?
How do I delete a row in mysql?
What is a join in mysql?
What is int mysql?
Explain MySQL optimization?
What is latest version of mysql?
How can I create database in mysql?
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)