å¦ä½å¨ORACLEæ°æ®åºçå段ä¸å»ºç«ç´¢å¼
CREATE INDEXå½ä»¤è¯æ³:
CREATE INDEX
CREATE [unique] INDEX [user.]index
ON [user.]table (column [ASC | DESC] [,column
[ASC | DESC] ] ... )
[CLUSTER [scheam.]cluster]
[INITRANS n]
[MAXTRANS n]
[PCTFREE n]
[STORAGE storage]
[TABLESPACE tablespace]
[NO SORT]
Advanced
å
¶ä¸ï¼
schema ORACLE模å¼ï¼ç¼ºçå³ä¸ºå½åå¸æ·
index ç´¢å¼å
table å建索å¼çåºè¡¨å
column åºè¡¨ä¸çååï¼ä¸ä¸ªç´¢å¼æå¤æ16åï¼longåãlong raw
åä¸è½å»ºç´¢å¼å
DESCãASC 缺ç为ASCå³ååºæåº
CLUSTER æå®ä¸ä¸ªèç°ï¼Hash clusterä¸è½å»ºç´¢å¼ï¼
INITRANSãMAXTRANS æå®åå§åæ大äºå¡å
¥å£æ°
Tablespace 表空é´å
STORAGE åå¨åæ°ï¼åcreate table ä¸çstorage.
PCTFREE ç´¢å¼æ°æ®å空é²ç©ºé´çç¾åæ¯(ä¸è½æå®pctused)
NOSORT ä¸ï¼è½ï¼æåºï¼åå¨æ¶å°±å·²æååºï¼æ以æåºä¸åæåºï¼
温馨提示:答案为网友推荐,仅供参考