Interested to Buy Any Domain ? << Click Here >> for more details...
What is indexing in mysql and how do we create indexing in
mysql
- 4 Answers
- 8269 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 a variable cost example?
What is the difference between implode() and explode() in php?
What is psr in php?
Explain about PHP filter and why it should be used?
How to remove values saved in the current session?
Why is php used?
Why session is required?
Is php still relevant 2019?
How to include a file code in different files in php?
What is the difference between apache vs niginx?
Write a select query that will be displayed the duplicated site name and how many times it is duplicated?
How to retrieve the original query string?
What is the use of extract function in php?
Tell me how can we get the error when there is a problem to upload a file?
Is age a variable in research?
