建ç«ç´¢å¼çè¯æ³æ ¼å¼å¦ä¸:CREATE (UNIQUEI[CLUSTER)INDEX<ç´¢å¼å>ON table I view(<åå>[<次åº>ãL<åå>t<次åº>]I ")å
¶ä¸çå
ç´ è¯´æå¦ä¸:table! viewè¦å»ºç«ç´ å¼çåºæ¬è¡¨æè
è§å¾çååãååè¦å»ºç«ç´¢å¼çåçååãç´¢å¼å¯ä»¥å»ºç«å¨è¯¥åºæ¬è¡¨çä¸åæè
å¤åä¸ï¼å个ååç¨éå·åéã次åºæå®ç´¢å¼å¼çæå次åºï¼å¯ä»¥ç¨ååºãASC)æè
éåº(DESC)ï¼ç³»ç»è½¯è®¤å¼ä¸ºååºãUNIQUE表ææ¯ä¸ä¸ªç´¢å¼å¼åªå¯¹åºå¯ä¸çæ°æ®ãCLUSTER表æè¦å»ºç«çç´¢å¼æ¯ç°ç´¢å¼ãä¸é¢å°ä¸¾ä¸ä¸ªä¾åæ¥å
·ä½è¯´æï¼ä»£ç å¦ä¸:CREATE UNIQUE CLUSTER INDEX Idxl ON Employee (EmployeeNo)该ä¾å°å¨EmployeeçEmployeeNo3Jä¸å»ºç«ä¸ä¸ªå¯ä¸ç°ç´¢å¼ï¼å¹¶ä¸Employeeç表ä¸çè®°å½å°æç
§Erå©loyceNcå¼çååºæå.ä¸é¢ä»£ç å°å¨å¤ä¸ªåä¸å»ºç«ç´¢å¼:CREATE UNIQUE CLUSTER INDEX Idxl ON Employee(EmployeeNo,Empename)建ç«ç´¢å¼æ¶æ以ä¸å ç¹éè¦èè:åªæ表æè§å¾çææè
æè½ä¸ºè¡¨å建索å¼ãæ¯ä¸ªè¡¨ä¸åªè½å建ä¸ä¸ªç°ç´¢å¼ã对äºç»å¸¸æ´æ°çåä¸å®å»ºç«ç°ç´¢å¼ãç´¢å¼åå¨è¡¨æè§å¾ä¸å¿
é¡»å¯ä¸ï¼ä½å¨æ°æ®åºä¸ä¸å¿
é¾ä¸ã
温馨提示:答案为网友推荐,仅供参考