Search
| 1 to 20 of 138 | Next » |
MySQL.com Search Results
1. MySQL :: The MySQL Cluster API Developers' Guide :: 4.5 The Index Class
4.5. The Index Class [ +/- ] 4.5.1. The Index::Type Type 4.5.2. Index Methods Abstract This section provides a reference to the Index class and its public members. Parent class. NdbDictionary Child classes. None Description. This class represents an index on an NDB Cluster table column. It is a descendant of the NdbDictionary class, via the Object class. For information on these, see Section 4.10, “The NdbDictionary Class” , and Section 4.19, “The Object Class” . Methods. The following table lists the p
» http://dev.mysql.com/doc/ndbapi/en/class-index.html
2. MySQL :: MySQL 5.0 Reference Manual :: 12.1.7 DROP INDEX Syntax
12.1.7. DROP INDEX Syntax DROP INDEX index_name ON tbl_name DROP INDEX drops the index named index_name from the table tbl_name . This statement is mapped to an ALTER TABLE statement to drop the index. See Section 12.1.2, “ ALTER TABLE Syntax” .
» http://dev.mysql.com/doc/refman/5.0/en/drop-index.html
3. MySQL :: MySQL 6.0 Reference Manual :: 12.1.13 DROP INDEX Syntax
12.1.13. DROP INDEX Syntax DROP INDEX index_name ON tbl_name DROP INDEX drops the index named index_name from the table tbl_name . This statement is mapped to an ALTER TABLE statement to drop the index. See Section 12.1.4, “ ALTER TABLE Syntax” . Indexes on variable-width columns are dropped online; that is, dropping the indexes does not require any copying or locking of the table. This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any speci
» http://dev.mysql.com/doc/refman/6.0/en/drop-index.html
4. MySQL :: MySQL 5.1 Reference Manual :: 12.1.13 DROP INDEX Syntax
12.1.13. DROP INDEX Syntax DROP [ONLINE|OFFLINE] INDEX index_name ON tbl_name DROP INDEX drops the index named index_name from the table tbl_name . This statement is mapped to an ALTER TABLE statement to drop the index. See Section 12.1.4, “ ALTER TABLE Syntax” . For NDB tables, beginning with MySQL Cluster NDB 6.2.5 and MySQL Cluster NDB 6.3.3, you can drop indexes online, using the ONLINE keyword. This means that the DROP operation does not require the affected table to be copied (and so the table is not
» http://dev.mysql.com/doc/refman/5.1/en/drop-index.html
5. MySQL :: MySQL 5.0 Reference Manual :: 12.5.5.4 LOAD INDEX INTO CACHE Syntax
12.5.5.4. LOAD INDEX INTO CACHE Syntax LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list ] ... tbl_index_list : tbl_name [[INDEX|KEY] ( index_name [, index_name ] ...)] [IGNORE LEAVES] The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE is used only for MyISAM tables. The IGNORE LEAVES modifier causes only blocks for the non-leaf nodes of the inde
» http://dev.mysql.com/doc/refman/5.0/en/load-index.html
6. MySQL :: MySQL 6.0 Reference Manual :: 12.5.6.4 LOAD INDEX INTO CACHE Syntax
12.5.6.4. LOAD INDEX INTO CACHE Syntax LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list ] ... tbl_index_list : tbl_name [[INDEX|KEY] ( index_name [, index_name ] ...)] [IGNORE LEAVES] The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE is used only for MyISAM tables. It is not supported for tables having user-defined partitioning (see Section 19.
» http://dev.mysql.com/doc/refman/6.0/en/load-index.html
7. MySQL :: MySQL 5.1 Reference Manual :: 12.5.5.4 LOAD INDEX INTO CACHE Syntax
12.5.5.4. LOAD INDEX INTO CACHE Syntax LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list ] ... tbl_index_list : tbl_name [[INDEX|KEY] ( index_name [, index_name ] ...)] [IGNORE LEAVES] The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE is used only for MyISAM tables. It is not supported for tables having user-defined partitioning (see Section 19.
» http://dev.mysql.com/doc/refman/5.1/en/load-index.html
8. MySQL :: MySQL 5.1 Reference Manual :: 12.5.4.18 SHOW INDEX Syntax
12.5.4.18. SHOW INDEX Syntax SHOW INDEX FROM tbl_name [FROM db_name ] SHOW INDEX returns table index information. The format resembles that of the SQLStatistics call in ODBC. SHOW INDEX returns the following fields: Table The name of the table. Non_unique 0 if the index cannot contain duplicates, 1 if it can. Key_name The name of the index. Seq_in_index The column sequence number in the index, starting with 1. Column_name The column name. Collation How the column is sorted in the index. In MySQL, this can
» http://dev.mysql.com/doc/refman/5.1/en/show-index.html
9. MySQL :: MySQL 5.1 Reference Manual :: 12.5.5.1 CACHE INDEX Syntax
12.5.5.1. CACHE INDEX Syntax CACHE INDEX tbl_index_list [, tbl_index_list ] ... IN key_cache_name tbl_index_list : tbl_name [[INDEX|KEY] ( index_name [, index_name ] ...)] The CACHE INDEX statement assigns table indexes to a specific key cache. It is used only for MyISAM tables. The following statement assigns indexes from the tables t1 , t2 , and t3 to the key cache named hot_cache : mysql> CACHE INDEX t1, t2, t3 IN hot_cache; +---------+--------------------+----------+----------+ | Table | Op | Msg_type
» http://dev.mysql.com/doc/refman/5.1/en/cache-index.html
10. MySQL :: MySQL 5.0 Reference Manual :: 12.5.5.1 CACHE INDEX Syntax
12.5.5.1. CACHE INDEX Syntax CACHE INDEX tbl_index_list [, tbl_index_list ] ... IN key_cache_name tbl_index_list : tbl_name [[INDEX|KEY] ( index_name [, index_name ] ...)] The CACHE INDEX statement assigns table indexes to a specific key cache. It is used only for MyISAM tables. The following statement assigns indexes from the tables t1 , t2 , and t3 to the key cache named hot_cache : mysql> CACHE INDEX t1, t2, t3 IN hot_cache; +---------+--------------------+----------+----------+ | Table | Op | Msg_type
» http://dev.mysql.com/doc/refman/5.0/en/cache-index.html
11. MySQL :: MySQL 6.0 Reference Manual :: 12.5.6.1 CACHE INDEX Syntax
12.5.6.1. CACHE INDEX Syntax CACHE INDEX tbl_index_list [, tbl_index_list ] ... IN key_cache_name tbl_index_list : tbl_name [[INDEX|KEY] ( index_name [, index_name ] ...)] The CACHE INDEX statement assigns table indexes to a specific key cache. It is used only for MyISAM tables. The following statement assigns indexes from the tables t1 , t2 , and t3 to the key cache named hot_cache : mysql> CACHE INDEX t1, t2, t3 IN hot_cache; +---------+--------------------+----------+----------+ | Table | Op | Msg_type
» http://dev.mysql.com/doc/refman/6.0/en/cache-index.html
12. MySQL :: MySQL 6.0 Reference Manual :: 12.5.5.18 SHOW INDEX Syntax
12.5.5.18. SHOW INDEX Syntax SHOW INDEX FROM tbl_name [FROM db_name ] SHOW INDEX returns table index information. The format resembles that of the SQLStatistics call in ODBC. This statement requires some privilege for any column in the table. SHOW INDEX returns the following fields: Table The name of the table. Non_unique 0 if the index cannot contain duplicates, 1 if it can. Key_name The name of the index. Seq_in_index The column sequence number in the index, starting with 1. Column_name The column name.
» http://dev.mysql.com/doc/refman/6.0/en/show-index.html
13. MySQL :: MySQL 5.0 Reference Manual :: 12.5.4.13 SHOW INDEX Syntax
12.5.4.13. SHOW INDEX Syntax SHOW INDEX FROM tbl_name [FROM db_name ] SHOW INDEX returns table index information. The format resembles that of the SQLStatistics call in ODBC. SHOW INDEX returns the following fields: Table The name of the table. Non_unique 0 if the index cannot contain duplicates, 1 if it can. Key_name The name of the index. Seq_in_index The column sequence number in the index, starting with 1. Column_name The column name. Collation How the column is sorted in the index. In MySQL, this can
» http://dev.mysql.com/doc/refman/5.0/en/show-index.html
14. MySQL :: MySQL 5.1 Reference Manual :: 18.10.5 ndb_drop_index — Drop Index from NDB Table
18.10.5. ndb_drop_index — Drop Index from NDB Table ndb_drop_index drops the specified index from an NDB table. It is recommended that you use this utility only as an example for writing NDB API applications — see the Warning later in this section for details. Usage : ndb_drop_index -c connect_string table_name index -d db_name The statement shown above drops the index named index from the table in the database . Additional Options : None that are specific to this application. Warning Operations performed
» http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-utilities-ndb-drop-index.html
15. MySQL :: MySQL 5.0 Reference Manual :: 19.10.5 ndb_drop_index — Drop Index from NDB Table
19.10.5. ndb_drop_index — Drop Index from NDB Table ndb_drop_index drops the specified index from an NDB table. It is recommended that you use this utility only as an example for writing NDB API applications — see the Warning later in this section for details. Usage : ndb_drop_index -c connect_string table_name index -d db_name The statement shown above drops the index named index from the table in the database . Additional Options : None that are specific to this application. Warning Operations performed
» http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-utilities-ndb-drop-index.html
16. MySQL :: MySQL 6.0 Reference Manual :: 18.10.5 ndb_drop_index — Drop Index from NDB Table
18.10.5. ndb_drop_index — Drop Index from NDB Table ndb_drop_index drops the specified index from an NDB table. It is recommended that you use this utility only as an example for writing NDB API applications — see the Warning later in this section for details. Usage : ndb_drop_index -c connect_string table_name index -d db_name The statement shown above drops the index named index from the table in the database . Additional Options : None that are specific to this application. Warning Operations performed
» http://dev.mysql.com/doc/refman/6.0/en/mysql-cluster-utilities-ndb-drop-index.html
17. MySQL :: MySQL 5.1 Reference Manual :: 13.5.13 InnoDB Table and Index Structures
13.5.13. InnoDB Table and Index Structures [ +/- ] 13.5.13.1. Physical Structure of an Index 13.5.13.2. Insert Buffering 13.5.13.3. Adaptive Hash Indexes 13.5.13.4. Physical Row Structure MySQL stores its data dictionary information for tables in .frm files in database directories. This is true for all MySQL storage engines. But every InnoDB table also has its own entry in the InnoDB internal data dictionary inside the tablespace. When MySQL drops a table or a database, it has to delete both an .frm file o
» http://dev.mysql.com/doc/refman/5.1/en/innodb-table-and-index.html
18. MySQL :: MySQL 5.0 Reference Manual :: 13.2.13 InnoDB Table and Index Structures
13.2.13. InnoDB Table and Index Structures [ +/- ] 13.2.13.1. Physical Structure of an Index 13.2.13.2. Insert Buffering 13.2.13.3. Adaptive Hash Indexes 13.2.13.4. Physical Row Structure MySQL stores its data dictionary information for tables in .frm files in database directories. This is true for all MySQL storage engines. But every InnoDB table also has its own entry in the InnoDB internal data dictionary inside the tablespace. When MySQL drops a table or a database, it has to delete both an .frm file o
» http://dev.mysql.com/doc/refman/5.0/en/innodb-table-and-index.html
19. MySQL :: MySQL 6.0 Reference Manual :: 13.5.13 InnoDB Table and Index Structures
13.5.13. InnoDB Table and Index Structures [ +/- ] 13.5.13.1. Physical Structure of an Index 13.5.13.2. Insert Buffering 13.5.13.3. Adaptive Hash Indexes 13.5.13.4. Physical Row Structure MySQL stores its data dictionary information for tables in .frm files in database directories. This is true for all MySQL storage engines. But every InnoDB table also has its own entry in the InnoDB internal data dictionary inside the tablespace. When MySQL drops a table or a database, it has to delete both an .frm file o
» http://dev.mysql.com/doc/refman/6.0/en/innodb-table-and-index.html
20. MySQL :: MySQL 5.1 with Maria Reference Manual :: 12.1.13 DROP INDEX Syntax
12.1.13. DROP INDEX Syntax DROP [ONLINE|OFFLINE] INDEX index_name ON tbl_name DROP INDEX drops the index named index_name from the table tbl_name . This statement is mapped to an ALTER TABLE statement to drop the index. See Section 12.1.4, “ ALTER TABLE Syntax” . For NDB tables, beginning with MySQL Cluster NDB 6.2.5 and MySQL Cluster NDB 6.3.3, you can drop indexes online, using the ONLINE keyword. This means that the DROP operation does not require the affected table to be copied (and so the table is not
» http://dev.mysql.com/doc/refman/5.1-maria/en/drop-index.html
| 1 to 20 of 138 | Next » |