~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/create_index.rst

• browse files at revision 2263.3.5
• compare with another revision
• download diff
• download tarball
• view history from revision 2263.3.5

• reverse the comparison (2263.3.5 to 2191)
• stop comparing with revision 2191

Show diffs side-by-side

added

removed

docs/create_index.rst

1

1

CREATE INDEX

2

2

============

3

3

 

4

 

CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...);

 

4

.. code-block:: mysql

 

5

 

 

6

   CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...);

5

7

 

6

8

An example:

7

9

 

8

10

.. code-block:: mysql

9

11

 

10

 

   CREATE INDEX table_1_index ON table_1 (a,b);

 

12

        CREATE INDEX table_1_index ON table_1 (a,b);

11

13

 

12

 

This would create an index on table_t named  table_1_index that convered

 

14

This would create an index on table_t named table_1_index that converged

13

15

columns a and b.

14

16

 

15

 

.. todo::

16

 

   

17

 

   how this is implemented currently. i.e. no fast add index

 

17

Fast index creation (where a storage engine can create or drop indexes

 

18

without copying and rebuilding the contents of the entire table) is

 

19

not implemented yet for Drizzle, but it is slated for the future.

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1