← Back to branch summary

~sharan-monikantan/drizzle/crashme

~sharan-monikantan/drizzle/crashme

« back to all changes in this revision

Viewing changes to docs/create_index.rst

Committer: Brian Aker
Date: 2012-06-22 06:48:16 UTC
mfrom: (2535.5.17 drizzle-7.1)
Revision ID: brian@tangent.org-20120622064816-c1n7dczhxffddlsr

Merge docs.

files modified:
docs/alter_schema.rst

docs/alter_table.rst

docs/commit.rst

docs/create_index.rst

docs/create_schema.rst

docs/create_table.rst

docs/ddl.rst

docs/delete.rst

docs/distinct.rst

docs/dml.rst

docs/drop_index.rst

docs/flush.rst

docs/functions/aggregatefunctions.rst

docs/functions/control_flow.rst

docs/functions/current_time_functions.rst

docs/functions/date_trunc.rst

docs/functions/datetime.rst

docs/functions/extract_date_functions.rst

docs/functions/logical.rst

docs/functions/overview.rst

docs/functions/string.rst

docs/functions/string/comparative.rst

docs/functions/string/conversion.rst

docs/functions/string/length.rst

docs/functions/string/modification.rst

docs/functions/string/other.rst

docs/functions/string/position.rst

docs/groupby.rst

docs/having.rst

docs/insert.rst

docs/join.rst

docs/load_data_infile.rst

docs/orderby.rst

docs/queries.rst

docs/rename.rst

docs/resources/ascii_chart.rst

docs/savepoints.rst

docs/start_transaction.rst

docs/string_data_types.rst

docs/tables.rst

docs/transactional.rst

docs/update.rst

docs/uuid_data_type.rst

docs/where.rst

Show diffs side-by-side

added added

removed removed

docs/create_index.rst

5

5

6

6

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

7

7

8

An example:

9

10

.. code-block:: mysql

11

12

CREATE INDEX table_1_index ON table_1 (a,b);

13

14

This would create an index on table_t named table_1_index that converged

15

columns a and b.

16

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.

8

'TODO'

b'\\ No newline at end of file'

Older »