What is indexing in mysql and how do we create indexing in
mysql
- 4 Answers
- 6960 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh n
Indexes are created on a per column basis. If you have a
table with the columns: name, age, birthday and employeeID
and want to create an index to speed up how long it takes to
find employeeID values in your queries, then you would need
to create an index for employeeID. When you create this
index, MySQL will build a lookup index where employeeID
specific queries can be run quickly. However, the name, age
and birthday queries would not be any faster.
Indexes are something extra that you can enable on your
MySQL tables to increase performance,cbut they do have some
downsides. When you create a new index MySQL builds a
separate block of information that needs to be updated every
time there are changes made to the table. This means that if
you are constantly updating, inserting and removing entries
in your table this could have a negative impact on performance.
syntax
CREATE TABLE <table name> (
<filed name> <field type>....
)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is empty () in php?
What is fetch array in php?
How to convert strings to upper or lower cases?
What is ci framework in php?
Explain me difference between mysql_connect and mysql_pconnect?
How to find the length of a string?
What is framework in php?
What does mvc stand for and what does each component do?
Can I include php in javascript?
What are the design patterns in php?
What is the difference server side and browser side validation?
How to find current date and time?
Why use php artisan serve?
What is difference between get and post?
How to create reusable code in php?
