【SAP HANA 14】 索引（Index）

创建索引
 

CREATE INDEX IDX_EXT_SERVICE_CODE ON WIP.Z_SERVICE_LOG (SERVICE_CODE);
CREATE INDEX IDX_EXT_START_TIME ON WIP.Z_SERVICE_LOG (START_TIME);
CREATE INDEX IDX_EXT_END_TIME ON WIP.Z_SERVICE_LOG (END_TIME);

-- 创建唯一索引
CREATE UNIQUE INDEX Z_EXT_CODE_EXT_CODE_IDX ON WIP.Z_EXT_CODE (EXT_CODE) ;

 

删除索引

DROP INDEX my_index; 

索引实战操作

-- ********************************************************************************* 索引 BEGIN 
-- 普通索引创建:  索引创建如下
CREATE INDEX IDX_TRANS_LOG ON Trans_log(First_name,Mid_name,Last_name, City);
CREATE INDEX IDX_Cust_idx ON Cust_inf (First_name,Mid_name,Last_name,City);
--可以对每个字段都创建索引
CREATE INDEX I DX_TRANS_LOG_F ON Trans_log(First_name) ;
CREATE INDEX I DX_TRANS_LOG_M ON Trans_log(Mid_name) ;
CREATE INDEX I DX_TRANS_LOG_L ON Trans_log(Last_name) ;
CREATE INDEX I DX_TRANS_LOG_C ON Trans_log