What is indexing and how do you create an index in MySQL?

1.	What is indexing and how do you create an index in MySQL?
Answer» A DATABASE index is the structure of a fact that improves the velocity of operations in a table. It can be created the USAGE of one or greater columns, presenting the FOUNDATION for each fast random lookups and efficient ORDERING of getting admission to records. Indexes are used to locate rows with specific column values quickly. Example CREATE INDEX [index name] ON [table name]([column name]);

Answer»

A DATABASE index is the structure of a fact that improves the velocity of operations in a table. It can be created the USAGE of one or greater columns, presenting the FOUNDATION for each fast random lookups and efficient ORDERING of getting admission to records. Indexes are used to locate rows with specific column values quickly.

Example

CREATE INDEX [index name] ON [table name]([column name]);

Discussion

No Comment Found

Related InterviewSolutions

How do you create view in MySQL?
What is view in MySQL?
What is the difference between timestamp and datetime in MySQL?
How to convert a string to utf 8 in MySQL?
What is the degree of a table in MySQL?
How to upload a large file through phpmyadmin in MySQL?
What is temporary table in MySQL?
What is heap table in MySQL?
How do I count the number of records in a MySQL query?
How can I see all indexes on a table in MySQL Database?

What is indexing and how do you create an index in MySQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment