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
- 8116 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
Which is better wamp or xampp?
When use javascript vs php?
Explain the three different kinds of Arrays?
What is the best php version for wordpress?
Which operator is used to combine string values in php?
With a heredoc syntax, do I get variable substitution inside the heredoc contents?
Explain what are the three classes of errors that can occur in php?
What is return in php function?
What is difference between strstr() and stristr()?
How to genrate report in wordpress cms
What is difference between Method overriding and overloading in PHP?
What is new static in php?
What is use of preg_replace in php?
What are the different errors in php?
What is cookie and session in php?
