ORACLE创建索引
create index 索引名称 on 表名(列名);
create index 索引名称 on 表名(列名1,列名2);
ORACLE查看索引
select * from all_indexes where table_name = '表名称';
select* from all_ind_columns where table_name = '表名称';
ORACLE删除索引
drop index 索引名称;
MYSQL创建索引
ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` );
ALTER TABLE `table_name` ADD UNIQUE (`column`);
ALTER TABLE `table_name` ADD INDEX index_name ( `column` );
ALTER TABLE `table_name` ADD FULLTEXT ( `column`);
ALTER TABLE `table_name` ADD INDEX index_name ( `column1`, `column2`, `column3` );
MYSQL查看索引索引
show index from tblname;
show keys from tblname;
MYSQL删除索引
DROP INDEX index_name ON talbe_name
ALTER TABLE table_name DROP INDEX index_name
ALTER TABLE table_name DROP PRIMARY KEY