Oracle索引相关
摘要:
--创建索引create index kg_yonghuxxkz1_cidxiazai on kg_yonghuxxkz1 (s_cid,d_xiacihbrq); --找出某张表的所有索引 select * from user_indexes where table_name= upper('kg_yonghuxxkz1') --对索引添加监视alter index KG_YONGHUXXKZ1_D_XIACIHBRQmonitoring usage;--查询语句select /*+ RULE */ * from kg_yonghuxxkz1 where d_xiacihbr 阅读全文
posted @ 2012-05-03 11:04 zyi 阅读(115) 评论(0) 推荐(0) 编辑