SQL> select count(*) from dba_ind_columns where table_name = 'A' and column_name = 'ID'; COUNT(*)
----------
0SQL> create index AAA on A (ID);Index createdSQL> select * from dba_ind_columns where table_name = 'A' and column_name = 'ID';Index Owner Index Name Table Owner Table Name Column Name Column Position Column Length Char Length Descend
---------- -------- ------- ----- ----- ------ ------ ----- ---------
DZL AAA DZL A ID 1 22 0 ASC
----------
0Executed in 0.016 secondsSQL> 表示表A的字段Col1没有索引。