Difference between revisions of "Indexes"
From MyWiki
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
| − | + | CREATE INDEX part_of_name ON customer (name(10)); | |
<source lang="text"> | <source lang="text"> | ||
| + | |||
| + | |||
| + | SQL CREATE INDEX Syntax | ||
| + | |||
| + | Creates an index on a table. Duplicate values are allowed: | ||
| + | CREATE INDEX index_name | ||
| + | ON table_name (column_name) | ||
| + | SQL CREATE UNIQUE INDEX Syntax | ||
| + | |||
| + | Creates a unique index on a table. Duplicate values are not allowed: | ||
| + | CREATE UNIQUE INDEX index_name | ||
| + | ON table_name (column_name) | ||
| + | |||
| + | |||
create index your_index_name on your_table_name(your_column_name) using HASH; | create index your_index_name on your_table_name(your_column_name) using HASH; | ||
or | or | ||
create index your_index_name on your_table_name(your_column_name) using BTREE; | create index your_index_name on your_table_name(your_column_name) using BTREE; | ||
</source> | </source> | ||
Latest revision as of 13:38, 18 September 2014
SHOW INDEX FROM yourtable;
CREATE INDEX part_of_name ON customer (name(10));
SQL CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_name ON table_name (column_name) SQL CREATE UNIQUE INDEX Syntax Creates a unique index on a table. Duplicate values are not allowed: CREATE UNIQUE INDEX index_name ON table_name (column_name) create index your_index_name on your_table_name(your_column_name) using HASH; or create index your_index_name on your_table_name(your_column_name) using BTREE;
