oracle ÈçºÎ´´½¨Ë÷Òý

±ÈÈç˵ÎÒÏÖÔÚÓÐÒ»ÕÅ±í  a ÖÐ ÒªÒÔcidΪË÷Òý
  ÇëÎÊÎÒÔõô´´½¨ cid µÄË÷Òý£¿

---

create index index_name on a(cid);

---

create index indexName on a(cid);

---

create [unique] index index_name on a(cid) [tablespace index_tbspace];
uniqueÓÐʱ±íʾÊÇΨһË÷Òý¡£index_nameË÷ÒýÃû¡£ tablespace²»Ö¸¶¨Ê±ÎªÓû§±í¿Õ¼ä¡£

---

SQL code:
CREATE INDEX idx1_A ON A(cid) NOLOGGING;

---

#1µÄ²»´í

ÒýÓÃ

create index index_name on a(cid);

---

ÔÚÍøÉÏ¿´µ½±ðÈ˵ÄÀý×Ó  ÏÂÃ滹ÓÐ ±í¿Õ¼ä ÊÇʲôÒâ˼£¿

---

ÓÃtoadÖ®ÀàµÄ¹¤¾ß¸ü·½±ã£¬²»ÓüÇÃüÁî