What is indexing in mysql and how do we create indexing in
mysql
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 php in full?
How to convert strings to upper or lower cases?
What is array filter php?
What does csrf token mean?
How to create a session? How to set a value in session? How to remove data from a session?
How check submit button is clicked in php?
How to read a file in binary mode?
How to get number of elements in an array?
Which operator is used to combine string values in php?
What exactly is PHP?
Is c similar to php?
What are the benefits of using queries?
Which function is used in php to search a particular value in an array?
Is php used in 2019?
Is empty array php?