¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 413
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤E¤ë 07, 2006 6:37 pm ¤å³¹¥DÃD: ½Ð±Ð..ªí³æ©Ò«Øªº¯Á¤Þ©M¥Îindex on ...to ..©Ò«Øªº¯Á¤Þ.¦b¥\¥Î¤W¦³¦ó¤£¦P... |
|
|
§Ú·Q½Ð±Ðªº¬O..¦bªí³æ¤¤©Ò«Øªº¯Á¤Þ©M¥Îindex ©Ò«Øªº©Ò¥H..¦³¦ó¤£¦P..
ªí³æ¤¤©Ò«Øªº¯Á¤Þ.·|¦]ª¬ªp¦Ó®ø¥¢¶Ü?..
¥Îindex ©Ò«Øªº¯Á¤Þ..·|²£¥Í¤@Ó.idx¯Á¤ÞÀÉ.¦ý·|¬O¿W¤@©Ê½è..¤@©w¬O³o¼Ë¶Ü..ÁÙ¬O¥i¥H¿ï¾Ü°ß¤@¯ë©Ê½è©O?..
¦bªí³æ¤¤©Ò«Ø¥ßªº¯Á¤Þ..¥u¯à¥Îreindex«¾ã..¦ÓµLªk«·s«Ø¥ß¶Ü..¥Î«ü¥O¨Ó°õ¦æ..
ÁÂÁÂ.. |
|
¦^³»ºÝ |
|
 |
garfield Site Admin

µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2160
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤E¤ë 08, 2006 8:58 am ¤å³¹¥DÃD: |
|
|
¤@¯ë¬O¥Î index on ... tag ... ¨Ó«Ø¥ß ·|¦Û°Ê¶}±Òªº¯Á¤ÞÀÉ,
¦pªG¥Î idxÀÉ , ¤@Óidx¥u¯à¦³¤@Ó¯Á¤Þkey ¥B¶·n¤â°Ê¶}±Ò,
¤£·Q¥Î reindex ¥i¥H¥ý±N index ÀÉÃö³¬,
index «á¦A¶}±Ò´Nok. _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤E¤ë 08, 2006 10:53 am ¤å³¹¥DÃD: |
|
|
¬Ý¤£À´¦b»¡¤°»ò?
¤°»ò¬O"ªí³æ¤¤©Ò«Øªº¯Á¤Þ"?
°ò¥»¤Wvfp ªº¯Á¤Þ¥u¤À¬° idx ³æ¤@¯Á¤Þ(ª©¥»¬Û®e) ¤Î cdx µ²ºc¤Æ½Æ¦X¯Á¤Þ,
¨Ã¤£¨Ì¦bþ¸Ì«Ø¥ß¦Ó¤ÀÃþ.
©Ò¥H§ÚÓ¤H¶É¦V©ó§A»~¸Ñ¤F¯Á¤Þªº¹B§@¤è¦¡,
½Ð°Ñ¾\ Working with Tables(³B²z¸ê®Æªí®æ) ¤¤ªº Index Creation for Tables («Ø¥ß¸ê®Æ¯Á¤Þ) _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
liangszpt

µù¥U®É¶¡: 2004-11-18 ¤å³¹: 263 ¨Ó¦Û: ÆÎ东¬Ù²`¦`¥«
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤E¤ë 08, 2006 2:19 pm ¤å³¹¥DÃD: |
|
|
¡H¡H¡H
请楼¥D¦A¾ã²z¤U问题¡C _________________ §Úªº²z·Q¬O¯à¦¨为¥j¥Nªº¤@¦ì´I®a¤½¤l¡A
¤é±`¥Í¬¡´N¬O³Ü¯ù¥h©É»°|¡A没¨Æ带þÓ¤@¯Z¤p¥´¤â¦bµó¤W调戏¨}®a妇¤k¡C |
|
¦^³»ºÝ |
|
 |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 413
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 4:58 pm ¤å³¹¥DÃD: |
|
|
¤£¦n·N«ä..¤]³\§Ú»¡ªº¤£°÷²M·¡..¬O³o¼Ëªº..
¦b«Ø¥ß¸ê®Æªí®æ¤º¤S¤@¥\¯à¬°¯Á¤Þ..¥i¥H¦b³o«Ø¥ß³æ¤@Äæ¦ì¯Á¤Þ¤Î¦hÄæ¦ì¯Á¤Þ.¥ç¥i¿ï¾Ü¯Á¤Þ¤è¦¡..¦³¤@¯ë¯Á¤Þ.¿W¤@¯Á¤Þ.¥Dkey¯Á¤Þ...
¦ý..¤]¦³¤@¤¤¥ó¯Á¤Þªº¤è¦¡.¬O¦bµ{¦¡¤¤§Q¥Îindex on xx to xx «Ø¥ß¯Á¤Þ..
¤£À´ªº¬O..¨â¨â¤§®t²§³B..¤Î¬°¦ó¥Îindex on xx to xx ©Ò«Ø¥ßªº¯Á¤Þ¥u¯à¿W¤@¯Á¤Þ.¦]¬°¿W¤@¯Á¤Þ·|±N¬Û¦Pªº¸ê®Æ¦Û°Ê¹LÂo¦Ó¥u¥X²{¤@µ§..½Ð¦U¦ì¤j¤jÀ°¦£¸Ñµª..
ÁÂÁÂ |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:16 pm ¤å³¹¥DÃD: |
|
|
¤@ºØ¬O "µøÄ±¤Æ"ªº«Ø¥ß¤è¦¡,
¤@ºØ¬O ª½±µ¥H©R¥O«Ø¥ß .
¨âºØ¤è¦¡«Ø¥ß¥X¨Óªº³£¤@¼Ë.
®t§O¦b©ó§A¤£À´INDEX©R¥O
¥N½X: |
INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName]
[FOR lExpression]
[COMPACT]
[ASCENDING | DESCENDING]
[UNIQUE | CANDIDATE]
[ADDITIVE]
|
¦pªG§An«Ø ¿W¤@¯Á¤Þ
¥N½X: |
INDEX ON ITEM_NO TAG ITM_IDX01 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING UNIQUE ADDTIVE
|
«Ø¤@¯ë¯Á¤Þ
¥N½X: |
INDEX ON ITEM_NO TAG ITM_IDX02 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING ADDTIVE
|
«Ø Ô¿ï¯Á¤Þ
¥N½X: |
INDEX ON ITEM_NO TAG ITM_IDX03 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING CANDIDATE ADDTIVE
|
_________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:25 pm ¤å³¹¥DÃD: |
|
|
ÁÙ¬O§A§â CREATE TABLE ¸Ìªº PRIMARY KEY /UNIQUE þ¨Ç©R¥O »P INDEX ON ·d²V? _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 413
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:28 pm ¤å³¹¥DÃD: |
|
|
·PÁÂsyntech«ü¾É¡C¡C |
|
¦^³»ºÝ |
|
 |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 413
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:30 pm ¤å³¹¥DÃD: |
|
|
¤£¬Oªº¡C¡C¬O§Ú¤£¼ôindexªº«Ø¥ß¤è¦¡¡C¡CÁÂÁ§A¡C¡C |
|
¦^³»ºÝ |
|
 |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 413
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤E¤ë 14, 2006 6:36 pm ¤å³¹¥DÃD: |
|
|
À³¥Î..¤@¯ë¯Á¤Þ
¥N½X:
INDEX ON ITEM_NO TAG ITM_IDX02 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING ADDTIVE
§Úªº¸ê®Æ¦³8µ§..
a001
a001
a001
b001
b001
a001
a001
b001
¦b©R¥O¤U°õ¦æ¤W±ªº¤è¦¡..µ²ªG¥u³Ñ¨âµ§¸ê®Æ..
a001
b001
¤£ª¾¨º¥X¿ù..½Ð¦A«ü±Ð.. |
|
¦^³»ºÝ |
|
 |
impotence

µù¥U®É¶¡: 2005-02-21 ¤å³¹: 135 ¨Ó¦Û: Hong Kong
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤E¤ë 19, 2006 9:39 am ¤å³¹¥DÃD: |
|
|
§A¦³¨S¦³ SET UNIQUE ON ? _________________ ¤@Ó±`±`§Ñ°O Command ªº¤H ! |
|
¦^³»ºÝ |
|
 |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 413
²Ä 12 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤E¤ë 19, 2006 12:45 pm ¤å³¹¥DÃD: |
|
|
³á!¦n¹³¨S¦³..ÁÂÁ§Aªº´£¿ô..§Ú¸Õ¸Õ..¦A¦¸·PÁ©p.. |
|
¦^³»ºÝ |
|
 |
impotence

µù¥U®É¶¡: 2005-02-21 ¤å³¹: 135 ¨Ó¦Û: Hong Kong
²Ä 13 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤E¤ë 20, 2006 10:36 am ¤å³¹¥DÃD: |
|
|
§Ú¬O»¡ .... ¦pªG§A¥Î¤F set unique on ·|¥X²{¿ù»~ªºµ²ªG .... _________________ ¤@Ó±`±`§Ñ°O Command ªº¤H ! |
|
¦^³»ºÝ |
|
 |
|