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
- 8473 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya
Two type of indexing
Spatial indexes (created using SPATIAL INDEX):
1.Available only for MyISAM tables. Specifying a
SPATIAL INDEX for other storage engines results in an error.
2.Indexed columns must be NOT NULL.
3.In MySQL 5.0, the full width of each column is
indexed by default, but column prefix lengths are allowed.
However, as of MySQL 5.0.40, the length is not displayed in
SHOW CREATE TABLE output. mysqldump uses that statement. As
of that version, if a table with SPATIAL indexes containing
prefixed columns is dumped and reloaded, the index is
created with no prefixes. (The full column width of each
column is indexed.)
Nonspatial indexes (created with INDEX, UNIQUE, or PRIMARY KEY):
1.Allowed for any storage engine that supports spatial
columns except ARCHIVE.
2.Columns can be NULL unless the index is a primary key.
3.For each spatial column in a non-SPATIAL index except
POINT columns, a column prefix length must be specified.
(This is the same requirement as for indexed BLOB columns.)
The prefix length is given in bytes.
4.The index type for a non-SPATIAL index depends on the
storage engine. Currently, B-tree is used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can we swap two different string using php for example:-- before swapping:-- 1 string :-hello friend, 2 string :-my dear, after swapping that strings will be: 1.hello dear, 2.my friend.
How we get browser details of clients machine?
What are the uses of implode() function?
What is a controller in programming?
Which function would you use to insert a record into a database in php?
What are the differences between echo and print?
List some string function name in php?
What is asort php?
my english is not too good then what we apply for a php programer post
What are the design patterns in php?
Does php need a closing tag?
What is purpose of @ in Php?
Does mysql need php?
How can you pass a variable by reference?
Is null in php?
