FirebirdSQL/問答篇/Performance with joins and order by

出自VFP Wiki

(修訂版本間差異)
跳轉到: 導航, 搜尋
(如何改善 joins and order by 的執行效率)
(revert)
 
第14行: 第14行:
join ATHLETE A on A.ATHLETEID = SR.ATHLETEID
join ATHLETE A on A.ATHLETEID = SR.ATHLETEID
where RI.RANKINGID = 589044
where RI.RANKINGID = 589044
-
order by RI.PLACE IC库存,低价清仓!!Over 100000 units in stock !!!
+
order by RI.PLACE
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
SD 4Mx16-6 166Mhz  K4S641632H-TC60T  Samsung  20000@  91    Stock
+
-
SD 2Mx32-7 PC143  M12L64322A-7T  Elite MT  5000@  28    Stock
+
-
SD 2Mx32 PC143  HY57V643220DT-7  Hynix  11520@  45    Stock
+
-
SD 2Mx32 166MHz  HY57V643220DT-6  Hynix  --@  57    Stock
+
-
SD 2Mx32-7 PC143  MT48LC2M32B2TG-7  Micron  1000@  10    4 days
+
-
SD 2Mx32-6 PC166  MT48LC2M32B2TG-6  Micron  --@  95    4 days
+
-
SD 2Mx32-6 166MHz  MT48LC2M32B2TG-6  Micron  10000@  95    4 days
+
-
SD 2Mx32-7 143MHz  K4S6 43232F-TC70  Samsung  50000@  56    Stock
+
-
SD 2Mx32 PC143 Pb Free  HY57V643220DTP-6  Hynix  --@  62    Stock
+
-
SD 1Mx16-7 143MHz  EM636165TS-7  Etron  10000@  47    Stock
+
-
SD 1Mx16-7 143MHz Pb Free  EM636165TS-7G  Etron  30000@  48    Stock
+
-
SD 1Mx16-7 PC143 Pb Free  M12L16161A-7TG  Elite MT  30000@  51    Stock
+
-
SD 1Mx16 PC143  HY57V161610ET-7  Hynix  --@  51    1 day
+
-
SD 1Mx16-7 PC143 lead free  HY57V161610ETP-7  Hynix  --@  USD< font class="money">0.52    3 days
+
-
SD 1Mx16 PC166  HY57V161610ET-6  Hynix  20000@  53    Stock
+
-
SD 1Mx16-7 PC143  IS42S16100C1-7T  ISSI  100000@  47    1 day
+
-
SD 1Mx16-6 PC166  V54C316162VCT-6  Mosel Vitelic  30000@  50    Stock
+
-
SD 1Mx16-6 PC166 CL3 Pb Free  K4S161622H-UC60  Samsung  500000@  54    1 day
+
-
SD 1Mx16-6 PC166 CL3  K4S161622H-TC60  Samsung  --@  57    same day
+
-
SD 1Mx16-7 143MHz  W981616CH-7  Winbond  20000@  57    Stock
+
-
SDRAM- PC100
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
SD 16Mx8 PC133 CL3  K4S280832F-TC75  Samsung  8640@  00    Stock
+
-
SD 8Mx16-H 133MHz CL3  HY57V281620HCT-H  Hynix  34000@  U SD2.11    Stock
+
-
SD 8Mx16-H 133MHz CL3  HY57V281620ET-H  Hynix  --@  93    Stock
+
-
SD 8Mx16-6 166MHz  HY57V281620ET-6  Hynix  --@  02    Stock
+
-
SD 8Mx16-75 133MHz (Lead Free)  EDS1216AATA-75-E  Elpida  20000@  10    8 days
+
-
SD 8Mx16-75 133MHz CL3  HYB39S128160CT-7.5  Infineon  10500@  25    3 days
+
-
SD 8Mx16-75 133MHz CL3  MT48LC8M16A2TG-75  Micron  10000@  23    3 days
+
-
SD 8Mx16-7E 133MHz CL2 Pb Free  MT48LC8M16A2P-7E  Micron  1600@  35    2 days
+
-
SD 8Mx16-7E 143MHz CL2< /td>  MT48LC8M16A2TG-7E  Micron  5000@  45    4 days
+
-
SD 8Mx16-75 133MHz CL3  K4S281632F-TC75  Samsung  11520@  85    Stock
+
-
SD 8Mx16-75 133MHz CL3  K4S281632F-TC75T00  Samsung  50000@  88    1 day
+
-
SD 8Mx16-75 133MHz CL3  K4S281632F-TC75T  Samsung  50000@  84    1 day
+
-
SD 8Mx16-75 133MHz CL3 Pb Free  K4S281632F-UC75  Samsung  15341@  87    Stock
+
-
SD 8Mx16-75 133MHz CL3 Pb Free  K4S281632F-UC75T00  Samsung  8000@  82    Stock
+
-
SD 4Mx32 143MHz CL3  K4S283232E-TC75  Samsung  --@  64    Stock
+
-
SD 4Mx32-6 166MHz CL3  MT48LC4M32B2TG-6  Micron  --@  25    1 day
+
-
SD 8Mx8-75 PC133 CL3  K4S640832H-TC75  Samsung  6880@  35    3 days
+
-
SD 8Mx8-75 133MHz CL3  K4S640832H-TC75T00  Samsung  50000@  05    6 days
+
-
SD 4Mx16-7 143MHz  M12L64164A-7TG  Elite MT  20000@  90    Stock
+
-
SD 4Mx16-75 133MHz  EDS6416AHTA-75  Elpida  --@  93    1 day
+
-
SD 4Mx16-H 133MHz  HY57V641620ET-H  Hynix  43200@  86    Stock
+
-
SD 4Mx16 PC143  HY57V641620ET-7  Hynix  20160@  86    Stock
+
-
SD 4Mx16-75 PC133 CL3  MT48LC4M16A2TG-75  Micron  10000@  85    1 day
+
-
SD 4Mx16-75 133Mhz  ;K4S641632H-TC75  Samsung  25920@  84    Stock
+
-
SD 4Mx16-60 133Mhz Pb Free  K4S641632H-UC60  Samsung  30720@  88    Stock
+
-
SD 4Mx16-75 133Mhz Pb Free  K4S641632H-UC75 & nbsp;Samsung  19200@  84    Stock
+
-
SD 4Mx16-6 166Mhz  K4S641632H-TC60  Samsung  --@  88    Stock
+
-
SD 4Mx16-6 166Mhz  K4S641632H- TC60T00  Samsung  56000 @  94    1 day
+
-
SD 4Mx16-75 133Mhz  K4S641632H-TC75T00  Samsung  50000@  88    1 day
+
-
SD 4Mx32 143MHz CL3  K4S283232E-TC75  Samsung  11000@  USD3.64    Stock
+
-
SD 4Mx32-6 166MHz CL3  K4S283232E-TC60  Samsung  7859@  USD3.55    4 days
+
-
MT48LC4M32B2B5  Lead Free  4 Meg x 32 3.3
+
-
MT48LC4M32B2F5 Lead Plated  4 Meg x 32 3.3V VFBGA 90-ball 1
+
-
MT48LC4M32B2P Lead Free  4 Meg x 32 3.3V TSOP 86-pin 167 MHz 6ns
+
-
MT48LC4M32B2TG Lead Plated  4 Meg x 32
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
SDRAM- PC133
+
-
SD 128Mx4-75 133MHz CL3  EDS5104ABTA-75  Elpida  10000@  USD10.20    4 days
+
-
SD 64Mx8-75 133MHz CL3  EDS5108ABTA-75  Elpida  1477@  USD18.50    4 days
+
-
SD 64Mx8-75 133MHz CL3  K4S510832B-TC75  Samsung  --@  USD14.55    4 days
+
-
SD 64Mx4-75 133MHz CL3  K4S560432E-TC75  Samsung  36000@  10    3 days
+
-
SD 32Mx16-75 133MHz lead Free  K4S511632B-UC75  Samsung  1920@  USD13.20    4 days
+
-
SD 32Mx16-75 133MHz CL3  EDS5116ABTA-75  Elpida  3620@  USD19.00    4 days
+
-
SD 32Mx16-75 133MHz  K4S511632B-TC75T00  Samsung  2000@  USD12.00    4 days
+
-
SD 32Mx8 PC133 CL3  HY57V56820CT-H  Hynix  11520@  32    Stock
+
-
SD 32Mx8-7 133MHz CL2  HYB39S256800DT-7  Infineon  10500@  40    4 days
+
-
SD 32Mx8-75 133MHz CL3  HYB39S256800DT-7.5  Infineon  3000@  55    Stock
+
-
SD 32Mx8-75 133MHz CL3  MT48LC32M8A2TG-75  Micron  10000@  45    Stock
+
-
SD 32Mx8-75 133MHz CL3  K4S560832E-TC75T  Samsung  4000@  74    1 day
+
-
SD 32Mx8-75 133MHz CL3  K4S560832E-TC75  Samsung  11520@  65    1 day
+
-
SD 16Mx16-75E 133MHz CL3 Pb Free  EDS2516APTA-75-E  Elpida  7000@  00    10 days
+
-
SD 16Mx16-H 133MHz CL3  HY57V561620CT-H  Hynix  40320@  20    Stock
+
-
SD 16Mx16-H 133Mhz  HY57V561620CT-H  Hynix  11520@  27    Stock
+
-
SD 16Mx16-H 133MHz CL3 Pb free  HY57V561620CTP-H  Hynix  10560@  30    Stock
+
-
SD 16Mx16 PC133 Pb Free Ind Temp  MT48LC16M16A2P-75IT  Micron  2000@  90    4 days
+
-
SD 16Mx16-75 133MHz CL3  MT48LC16M16A2TG-75  Micron  10000@  70    Stock
+
-
SD 16Mx16-75 133 MHz  K4S561632E-TC75  Samsung  30000@  96    3 days
+
-
SD 16Mx16-75E 133MHz CL3 Pb Free  EDS2516ADTA-75-E  Elpida  10800@  25    Stock
+
-
SD 16Mx16-75 133 MHz PB Free  K4S561632E-UC75  Samsung  5760@  77    Stock
+
-
SD 16Mx8-75 133MHz CL3  UPD45128841G5-A75-9JF  Elpida  10000@  05    1 day
+
-
SD 16Mx8-75 133MHz CL3  MT48LC16M8A2TG-75  Micron  10000@  25    3 days
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
SD 4Mx16-102 PC100 CL2  MB81F641642D-102FN  Fujitsu  65130@  55    Stock
+
-
SD 2Mx8-8 PC125 CL2  MT48LC2M8A1TG-8BS  Micron  45000@  70    Stock
+
-
EDO Extende d Data Out
+
-
EDO 2Mx8-60 5V SOJ  GM71C17803CJ-6  Hyundai [LGS]  10000@  35    3 days
+
-
EDO 2Mx8-50 5V 2K SOJ  K4E160811C-BC50  Samsung  858@  60    3 days
+
-
EDO 2Mx8-60 5V 2K SOJ < td bgcolor="#FFFFFF" valign="top"> TC5117805CJ-60  Toshiba  8000@  60    3 days
+
-
EDO 1Mx16-60 5V 1K TSOP  AS4C1M16E5-60TC  Alliance  5000@  02    Stock
+
-
EDO 128Kx16 5V  HY512264TC-60  Hynix  5000@  42    Stock
+
-
EDO 4Mx4 3.3V TSOP  M11L1644SA-50T  ESMT  10000@  77    Stock
+
-
FPM Fast Page Mode
+
-
FPM 16Mx4-60 3.3 8K TSOP  M5M467400DTP-6  Mitsubishi  37190@  10    Stock
+
-
FPM 16Mx4-60 3.3V 4K SOJ  K4F640412D-JC6000  Samsung  31700@  65    3 days
+
-
FPM 8Mx8-60 3.3 4K TSOP  M5M467800DTP-6  Mitsubishi  62400@  10    Stock
+
-
FPM 4Mx4-60 3.3V 4K TSOP  K4F170412D-FC60  Samsung  20000@  15    5 days
+
-
FPM 4Mx4-60 5V 4K SOJ  K4F170411D -BC60  Samsung  7000@  15    3 days
+
-
FPM 4Mx4-60 3.3V 4K TOSP  K4F170412C-FC60  Samsung  960@  10    3 days
+
-
FPM 1Mx16-60 3.3V 1K TSOP  GM71V18160CT-60  Hynix  5000@  78    Stock
+
-
FPM 1Mx16-50 3.3V TSOP  KM416V1200CT-5  Samsung  520@  60    3 days
+
-
FPM 1Mx16-60 5V 1K TSOP  MT4C1M16C3TG-6  Micron  2000@  85    3 days
+
-
FPM 1Mx16-60 3.3V 1K TSOP  TC51V18160CFTS-60  Toshiba  3900@  10    3 days
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
AMD
+
-
AM29LV160DT-90EC AMD 1440 03+ STOCK,480/BOX
+
-
AM29LV160DT-90EC AMD 15000 03+ 3days
+
-
AM29LV160MB-70EI AMD 10000 04+ 3days
+
-
AM29LV160MB-90EI AMD 10000 04+ 7days
+
-
AM29LV320DB-90EI AMD 5000 03+ 3days
+
-
AM29LV320MB100REI AMD 3000 02+ 5days
+
-
AM29LV320MB-95REC AMD 20000 04+ 5days
+
-
AM29LV400BB-120WAI AMD 20000 03+ 4DAYS
+
-
AM29LV400BB-90EI AMD 10000 03+ 3days
+
-
AM29LV640MH-120REI AMD 3000 03+ 4days
+
-
AM29LV640MH-90REI AMD 413 03+ 4days
+
-
AM29LV800BB-120EC AMD 30000 02+ 4-5DAYS
+
-
AM29LV800BB-70EC AMD 20000 03+ 4-5DAYS
+
-
AM29LV800DB-70EC AMD 30000 03+ 3DAYS
+
-
AM29LV800DB-90EC AMD 30000 03+ 4-5DAYS
+
-
AM29LV800DT-70EC AMD 10000 03+ 3DAYS
+
-
AM29LV800DT-90EC AMD 10000 03+ 3DAYS
+
-
 
+
-
Macronix
+
-
 
+
-
MX29F400BTC-70  Macronix 9000 03+ 3days
+
-
MX29F400BTC-90 Macronix 5000 03+ 3days
+
-
MX29LV081TC-70                  Macronix           
+
-
MX29LV160ABTC-70 Macronix 20000 04+ 3days,768/BOX
+
-
MX29LV160ABTC-90 Macronix 20000 04+ 5days
+
-
MX29LV320ABTC-70 Macronix 10000 03+ 3days
+
-
MX29LV320ABTC-90  Macronix 10000 03+ 3days
+
-
MX29LV400BTC-90 Macronix 5000 03+ 3days
+
-
MX29LV400TTC-90 Macronix 30000 04+ 3days
+
-
 
+
-
MX29LV800BTC-70 Macronix 20000 03+ 3days
+
-
MX29LV800BTC-90 Macronix 20000 03+ 3days
+
-
MX29LV800TTC-90 Macronix 30000 03+ 4-5DAYS
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
Fujitsu
+
-
 
+
-
MBM29F400TC-70PFTN Fujitsu 1920 04+ STOCK
+
-
MBM29LV160BE-70TN    Fujitsu 10000 03+ 3days ,960/BOX
+
-
MBM29LV160TE-70TN Fujitsu 5000 03+ 3days
+
-
MBM29LV200BC-70PFTN Fujitsu 50000 00+ 3days
+
-
MBM29LV200TC-90PFTN Fujitsu 10000 00+ 3days
+
-
MBM29LV320BE-90TN Fujitsu 10000 03+ 4days
+
-
MBM29LV400BC-70PFTN Fujitsu 20000 03+ 3days,960/BOX
+
-
MBM29LV400BC-90PFTN Fujitsu 11520 03+ 3days
+
-
MBM29LV400TC-90PFTN Fujitsu 5000 03+ 3days
+
-
MBM29LV800BE-70TN Fujitsu 15000 03+ 3days
+
-
MBM29LV800BE-70TN Fujitsu 3840 04+ STOCK
+
-
MBM29LV800BE-90PBT  Fujitsu 30000 03+ 3days
+
-
 
+
-
 
+
-
MBM29LV800BE-90TN Fujitsu 15000 03+ 3days
+
-
MBM29LV800TA-90PFTN Fujitsu 1389 04+ STOCK
+
-
MBM29LV800TE-70PFTN Fujitsu 5000 03+ 3days
+
-
MBM29LV800TE-70TN Fujitsu 10000 03+ 3days
+
-
 
+
-
 
+
-
M29W320DB-90N6  ST 9798 04+ 3days
+
-
M29W800DB-70N6 ST 5000 03+ STOCK
+
-
M29W800DT-90N6 ST 5000 03+ 4-5DAYS
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
Graphic DDR
+
-
GDDR3 8Mx32 500Mhz FBGA144  K4J55323QF-GC20  Samsung  10000@  25    1 day
+
-
GDDR 16Mx16 200MHz TSOP  HY5DU561622CT-5  Hynix  5760@  40    Stock
+
-
GDDR 16Mx16 200MHz TSO P Pb Free  HY5DU561622DTP-5  Hynix  11520@  32    1 day
+
-
GDDR 16Mx16 200MHz TSOP  HY5DU561622DT-5  Hynix  11520@  32    Stock
+
-
GDDR 16Mx16 200MHz  HYB25D256161CE-5  Infineon  --@  28    1 day
+
-
GDDR2 16Mx16  K4N56163QF-GC2AT00  Samsung  10000@  72    1 day
+
-
GDDR 16Mx16 200Mhz TSOP  K4D551638F-TC50  Samsung  10000@  20    Stock
+
-
GDDR 8Mx16 200MHz TSOP  K4D261638F-TC50  Samsung  10000@  08    Stock
+
-
GDDR 8Mx16 200MHz  K4D261638I-TC50  Samsung  10000@  98    1 day
+
-
GDDR 4Mx32 300MHz FPGA  HY5DU283222AFP-33  Hynix  --@  58    Stock
+
-
GDDR 4Mx32 200MHz  K4D263238F-UC50  Samsung  8000@  07    11 Dec
+
-
GDDR 16Mx16 166MHz TSOP-66 Pb Free  HYB25D256163CE-6  Infineon  --@  20    1 day
+
-
GDDR 16Mx16  K4D551638F-TC50T00  Samsung  20000@  90    2 days
+
-
DDR2
+
-
DDR2 32Mx8 PC533 Pb free  HYB18T256800AF-3.7  Infineon  14000@  60    3 days
+
-
DDR2 32Mx8 PC533 (Lead Free)  K4T56083QF-ZCD5  Samsung  10000@  10    3 days
+
-
DDR2 64Mx8 PC 400 Lead Free  HYB18T512800AF-5  Infineon  10000@  95    5 days
+
-
DDR2 32Mx16 PC400 Lead Free BGA  HYB18T512160AF-5  Infineon  12000@  95    3 days
+
-
DDR2 64Mx8 PC533 FBGA &nbs p;K4T51083QC-ZCD500  Samsung  15000@  20    3 days
+
-
DDR-400
+
-
DDR 64Mx8 PC400 Pb Free  K4H510838C-UCCC  Samsung  4800@  55    3 days
+
-
DDR 64Mx8 PC400  MT46V64M8TG-5B  Micron  --@  80    3 days
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
DDR 64Mx8 PC400 Pb Free  MT46V64M8P-5B  Micron  50000@  10    2 days
+
-
DDR 64Mx8 PC400 Pb Free  HY5DU12822CTP-D43  Hynix  23040@  85    3 days
+
-
DDR 32Mx16 PC400 TSOP  HY5DU121622CTP-D43  Hynix  11520@  75    Stock
+
-
DDR 32Mx8 PC400  K4H560838F-TCCC  Samsung  11520@  39    Stock
+
-
DDR 32Mx8 PC400 Pb Fee  K4H560838F-UCCC000  Samsung  9385@  50    3 days
+
-
DDR 32Mx8 PC400 3-3-3  HY5DU56822CT-D43  Hynix  5314@  03    1 day
+
-
DDR 32Mx8 PC400  HY5DU56822DT-D43  Hynix  17280@ &n bsp;06    Stock
+
-
DDR 32Mx8 PC400 3-4-4  EDD2508AMTA-5B  Elpida  50000@  92    1 day
+
-
DDR 32Mx8-5 PC400  MT46V32M8TG-5B  Micron  10000@  90    Stock
+
-
DDR 32Mx8 PC400 PB Free  HYB25D256800CE-5  Infineon  20000@  10    1 day
+
-
DDR 32Mx8 PC400  EDD2508ARTA-5B  Elpida  --@  91    Stock < /tr>
+
-
DDR 32Mx8 PC400 BGA  HYB25D256800CC-5  Infineon  10000@  55    3 days
+
-
DDR 32Mx8 PC400  HY5DU56822BT-D43  Hynix  23040@  40    Stock
+
-
DDR 16Mx16 PC400 3-3-3 TSOP 400 mil  HYB25D256160CE-5  Infineon  6000@  70    1 day
+
-
DDR 16Mx16 PC400  MT46V16M16TG-5B  Micron  10000@  20    1 day
+
-
DDR 16Mx16 PC400 Pb Free  MT46V16M16P-5B  Micron  12000@  45    5 days
+
-
DDR 16Mx16 PC400  K4H561638F-TCCC  Samsung  11520@  05    Stock
+
-
DDR-333
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
+
-
DDR 128Mx4 PC333  MT46V128M4TG-6T  Micron  10000@  USD7.10    3 days
+
-
DDR 64Mx8-J PC333 Pb Free  HY5DU12822CTP-J  Hynix  11520@  66    Stock
+
-
DDR 64Mx8 PC333  MT46V64M8TG-6T  Micron  10000@  60    Stock
+
-
DDR 64Mx4 PC333  HYB25D256400BE-6  Infineon  1500@  40    3 days
+
-
DDR 32Mx16 PC333 CL2.5 TSOP  MT46V32M16TG-6T  Micron  10000@  55    booking
+
-
DDR 32Mx16 PC333 Pb Free  HY5DU121622CTP-J  Hynix  5760@  65    Stock
+
-
DDR 32MX16 PC333 Pb Free  HY5DU121622BTP-J  Hynix  5760@  80    Stock
+
-
DDR 32Mx8 PC333  EDD2508AKTA-6B  Elpida  21600@  98    Stock
+
-
DDR 32Mx8 PC333 CL2.5  HY5DU56822DT-J-A  Hynix  14281@  35    3 days
+
-
DDR 32Mx8 PC333 CL2.5  HYB25D256800BT-6  Infineon  23040@  12    1 day
+
-
DDR 32Mx8 PC333 PB Free CL2.5  HYB25D256800CE-6  Infineon  10500@  25    1 day
+
-
DDR 32Mx8-6 PC333 Pb Free  MT46V32M8P-6T  Micron  20000@  25    2 days
+
-
DDR 32Mx8-6 PC333 FBGA CL2.5  MT46V32M8FG-6  Micron  20000@  45    3 days
+
-
DDR 32Mx8 PC333 CL2.5 Pb  HYB25D256800CF-6  Infineon  15000@  85    5 days
+
-
DDR 32Mx8 PC333  K4H560838F-TCB3  Samsung  19200@  50    3 days
+
-
DDR 32Mx8 PC333  M2S56D30ATP-60  Mitsubishi  4320@  65    3 days
+
-
DDR 16Mx16-J PC333 Pb Free  HY5DU561622DTP-J  Hynix  11520@  36    Stock
+
-
DDR 16Mx16 PC333  ;HYB25D256160CE-6  Infineon  15000@  85    2 days
+
-
DDR 16Mx16 PC333 Pb Free  MT46V16M16P-6T  Micron  6000@  85    2 days
+
-
DDR 16Mx16 PC333  MT46V16M16TG-6T  Micron < td bgcolor="#FFFFFF" valign="top" align="right"> 4000@  25    4 days
+
-
DDR 16Mx16 PC333 Lead Free  K4H561638F-UCB3  Samsung  30000@  65    2 days
+
-
DDR 16Mx8 PC333 Lead Free  HYB25D128800CE-6  Infineon  50000@< /td>  31    3 days
+
-
DDR-266
+
-
DDR 64Mx8 PC266 BGA  MT46V64M8FN-75  Micron  20000@  60    Stock
+
-
DDR 64Mx4 PC266 CL2.5  K4H560438D-TCB0  Samsung  480@  05    Stock
+
-
DDR 32Mx4 PC266 CL2.5  HY5DU28422BT-HDR  Hynix  --@  80    2 days
+
-
DDR 32Mx4 PC266 CL2 Pb Free  HYB25D128400CE-7  Infineon  30000@  35    3 days
+
-
DDR 16Mx8-B0 PC266  K4H280838F-TCB0  Samsung  16000@  05    Stock
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
Nand Flash
+
-
16G bit Nand Flash  K9WAG08U1M-PCB0  Samsung  960@ 
+
-
8G bit Nand Flash lead free 90nm Dual Die  K9W8G08U1M-PCB0  Samsung  1000@ 
+
-
8G bit Nand Flash Pb Free 90nm Dual Die  K9W8G08U1M-PCB0T  Samsung  5000@ 
+
-
8G bit Nand Flash  K9K8G08U1M-PCB0  Samsung  1000@ 
+
-
4G bit Nand Flash  K9K4G08U0M-YCB0  Samsung  4000@ 
+
-
4G bit Nand Flash Pb free  K9K4G08U0M-PCB0  Samsung  2000@ 
+
-
4G bit Nand Flash Pb free  K9K4G08U0M-PCB0T  Samsung  2000@ 
+
-
4G bit Nand Flash  K9F4G08U0M-PCB0  Samsung  3000@ 
+
-
4G Nand Flash  K9K4G08U0M-PCB0T00  Samsung  1000@ 
+
-
2G bit Nand Flash Single Die row read disable  HY27UF082G2M-TCB  Hynix  1000@ 
+
-
2G bit Nand Flash Single Die row read disable  HY27UF082G2M-TPCB  Hynix  1920@ 
+
-
2G bit Nand Flash Dual Die row read disable  HY27UG082G2M-TCB  Hynix  2000@ 
+
-
2G bit Nand Flash 256Mx8 Pb free  MT29F2G08AABWP  Micron  5000@ 
+
-
2G bit Nand Flash 256Mx8 Pb free  K9F2G08U0M-PCB0  Samsung  1000@ 
+
-
2G bit Nand Flash  K9K2G08U0M-PCB0  Samsung  2000@ 
+
-
2G bit Nand Flash Pb Free  K9F2G08U0M-PCB0  Samsung  1000@ 
+
-
2G bit Nand Flash 256Mx8  TC58NVG1S3BTG00  Toshiba  960@ 
+
-
2G bit Nand Flash 256Mx8  TC58NVG1S3BFT00  Toshiba  2600@ 
+
-
2G bit Nand Flash 256Mx8  TC58NVG1S3AFT05  Toshiba  2600@ 
+
-
1G bit Nand Flash mono die row read disable  HY27UF081G2M-TCB  Hynix  5760@ 
+
-
1G bit Nand Flash mono die row read disable  HY27UF081G2M-TPCB  Hynix  3840@ 
+
-
1G bit Nand Flash 128Mx8  K9K1G08U0M-YCB0  Samsung  1000@ 
+
-
1G bit Nand Flash 128Mx8  K9F1G08U0A-YCB0  Samsung  10000@ 
+
-
1G bit Nand Flash 128Mx8 Pb Free  K9F1G08U0A-PCB0  Samsung  10000@ 
+
-
1G bit Nand Flash 128Mx8 Pb Free  K9F1G08U0A-PCB0T  Samsung  10000@ 
+
-
1G bit Nand Flash 128Mx8  K9F1G08U0A-YCB0T  Samsung  10000@ 
+
-
1G bit Nand Flash 128Mx8 TSOP I-48  TC58DVG02A1FT00  Toshiba  960@ 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
512M bit Nand Flash 64Mx8  K9F1208U0M-YCB0  Samsung  960@ 
+
-
512M bit Nand Flash 32Mx8  K9F1208U0B-PCB0T  Samsung  8000@ 
+
-
256M bit Nand Flash x8 3.3V Pb Free  HY27US08561A-TPCB  Hynix  14000@ 
+
-
256M bit Nand Flash  K9F5608U0C-YCB0  Samsung  2000@ 
+
-
256M bit Nand Flash  K9F5608U0C-PCB0  Samsung  2000@ 
+
-
256M bit Nand Flash  K9F5608U0C-DCB0  Samsung  5000@ 
+
-
256M bit Nand Flash  K9F5608U0C-PIB0  Samsung  13000@ 
+
-
256M bit Nand Flash  K9F5608U0B-PIB0  Samsung  10000@ 
+
-
256M bit Nand Flash  K9F5616U0B-YIB0  Samsung  5000@ 
+
-
256M bit Nand Flash  K9F5608U0B-YIB0  Samsung  10000@ 
+
-
64M bit Nand Flash  K9F6408U0C-TCB0  Samsung  3000@ 
+
-
1G bit Nand Flash  K9F1G08U0A-YCB0T  Samsung  10000@ 
+
-
Flash Memory
+
-
256M Flash Memory  TE28F256J3C-125  Intel  960@ 
+
-
256M Flash Memory  RC28F256J3C-125  Intel  5000@ 
+
-
128M Flash Memory  RC28F128K3C-115  Intel  400@ 
+
-
64M Flash Memory  DT28F640J5A-150  Intel  5000@ 
+
-
64M Flash Memory  RC28F640J3C-120  Intel  10000@ 
+
-
32M Flash Memory  AM29LV320DB-90WMI  AMD  500@ 
+
-
32M Flash Memory  TE28F320J3C-110  Intel  3072@ 
+
-
16M Flash Memory TSOP  AM29LV160DB-90EC  AMD  2000@ 
+
-
16M Flash Memory  TE28F160C3BD-70  Intel  10000@ 
+
-
16M Flash Memory  TE28F160C3TD-70  Intel  30000@ 
+
-
16M Flash Memory TSOP  TE28F160S5-70  Intel  292@ 
+
-
8M Flash Memory  TE28F800C3TA-90  Intel  10000@ 
+
-
8M NOR Flash Memory  SST39VF800A-70-4C-EK  SST  10000@ 
+
-
4M Flash Memory  AM29LV400BB-120EI  AMD  15000@ 
+
-
4M Flash Memory  HY29F400TT-55  Hyundai/00  8000@ 
+
-
4Mb Nor Flash SOP 5V  MT28F400B5SG-8BET  Micron  5000@ 
+
-
4M Flash Memory  SST28SF040A-90-4C-NH  SST  500@ 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
128M Flash Memory  TE28F128J3C-120  Intel  2000@ 
+
-
Static RAM
+
-
SRAM 512Kx16-7 Low Low Ind Temp  K6F8016U6B-EF70T  Samsung  300@ 
+
-
SRAM 128Kx8-55 TSOP  HY628100BLLT1-55I  Hynix  30000@ 
+
-
SRAM 128kx8 SOP LLP  HY628100BLLG-55  Hynix  5000@ 
+
-
SRAM 128Kx8-70H  M5M51008DVP-70H  Mitsubishi  5000@ 
+
-
SRAM 128Kx8-10 SOP  K6R1008C1C-JC10000  Samsung  1000@ 
+
-
SRAM 128Kx8-70H  M5M51008DVP-70HI  Mitsubishi  5000@ 
+
-
SRAM 128Kx8-7 SOP  K6T1008C2E-GB70  Samsung  12000@ 
+
-
SRAM 128Kx8-70 SOP  TC551001CF-70L  Toshiba  5000@ 
+
-
SRAM 64Kx16-12  K6R1016V1C-TI12  Samsung  1500@ 
+
-
SRAM 32Kx8-70 DIP  HY62CT08081E-DP70C  Hynix  6500@ 
+
-
SRAM 8Kx8-10 DIP  HM6264BLP-10L  Hitachi  80@ 
+
-
SRAM 512Kx8-12  K6R4008V1D-JC10  Samsung  1000@ 
+
-
4M Fast SRAM  K6R4008V1D-TI10T00  Samsung  16000@ 
+
-
SRAM 128Kx8  K6T1008C2E-GB55  Samsung  5000@ 
+
-
SRAM 128KX8-70  K6X1008T2D-TB70  Samsung  2000@ 
+
-
SRAM 512kx8 Ind Temp  K6X4008C1F-DF55  Samsung  400@ 
+
-
SRAM 512kx8  K6X4008C1F-VF55  Samsung  30000@ 
+
-
SRAM 512kx8  K6X4008C1F-VF70  Samsung  30000@ 
+
-
SRAM 64Kx16  K6R1016V1D-TC10T00  Samsung  5000@ 
+
-
SRAM 64Kx16  K6R1016V1D-TI10  Samsung  15000@ 
+
-
SRAM 128Kx8 Slow SOP  LP621024DM-70LL  Elite MT  1000@ 
+
-
SRAM 128Kx8  K6X1008C2E-TF55  Samsung  8000@ 
+
-
SRAM 128KX8-70 Lead Free  K6X1008T2D-BF70T  Samsung  5000@ 
+
-
SRAM 1MX36  K7N323645M-QC16  Samsung  1500@ 
+
-
EPROM
+
-
EEPROM  AT24C256-10PI-2.7  Atmel  10000@ 
+
-
EPROM  AT89C2051-24PI  Atmel  5000@ 
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
Samsung
+
-
 
+
-
K4S161622ETC-60 SAM 500 02+
+
-
K4S161622HTC-60 SAM 960 04+
+
-
K4S641632H-TC75 SAM 480 03+
+
-
K4S641632F-TC75 SAM 1920 04+
+
-
K4S643232F-TC60 SAM 50 02+
+
-
K4S281632DTC-75 SAM 500 03+
+
-
K4S281632ETC-75 SAM 1000 03+
+
-
K4S561632ETC-75 SAM 1500 03+
+
-
K4D261638E-TC36 Samsung 16000 03+ 3days
+
-
K4D261638F-TC40 Samsung 14000 04+ 3days
+
-
K4D261638F-TC50 Samsung 20000 04+ 3days
+
-
K4D263238E-GC2A Samsung 10000 03+
+
-
K4D26323RA-GC2A Samsung 8000 02+  5days
+
-
K4D26323RA-GC2B Samsung 8000 02+  5days
+
-
K4D551638F-TC50 Samsung 20000 04+ 3days
+
-
K4D623238B-QC50 Samsung 20000 03+ 3days
+
-
K4S161622D-TC80 Samsung 10000 02+ 3days
+
-
K4S161622H-TC60 Samsung 30000 03+ 5days
+
-
K4S280832D-TI75T00 Samsung 1503 03+ 3days
+
-
K4S280832F-TC75 Samsung 10000 03+ 3days
+
-
K4S281632E-TC75 Samsung 30000 03+ 3days
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
Micron
+
-
 
+
-
MT48LC16M16A2TG-75 Micron 20000 03+ 3days
+
-
MT48LC16M16A2TG-7E Micron 5000 03+ 3days
+
-
MT48LC16M8A2TG-75 Micron 10000 03+ 3days
+
-
MT48LC2M32B2TG-6 Micron 20000 03+ 3days
+
-
MT48LC2M32B2TG-7 Micron 5000 03+ 3days
+
-
MT48LC2M32B2TG-7IT Micron 5000 03+ 3days
+
-
MT48LC32M16A2TG-75 Micron 1000 03+ 3days
+
-
MT48LC4M16A2TG-75 Micron 1000 342 STOCK,RESEAL PACKING
+
-
MT48LC4M16A2TG-75 Micron 5000 04+ 3days
+
-
MT48LC4M16A2TG-75IT Micron 20000 04+ 3-5days
+
-
MT48LC4M32B2TG-7 Micron 5000 03+ 5days
+
-
MT48LC8M16A2TG-75 Micron 20000 04+ 3days
+
-
MT48LC8M16A2TG-75IT Micron 10000 03+ 3days
+
-
MT4LC1M16C3DJ-6 MICRON 500 01+ STOCK,1K/REEL
+
-
MT4LC1M16E5DJ-5  MICRON 5000 02+ 3days
+
-
MT4LC1M16E5TG-5 MICRON 5000 02+ 3days
+
-
MT48LC4M32B2B5  Lead Free  4 Meg x 32 3.3
+
-
MT48LC4M32B2F5 Lead Plated  4 Meg x 32 3.3V VFBGA 90-ball 1
+
-
MT48LC4M32B2P Lead Free  4 Meg x 32 3.3V TSOP 86-pin 167 MHz 6ns
+
-
MT48LC4M32B2TG Lead Plated  4 Meg x 32
+
-
MT48LC2M32B2TG-7 MT 4000 00+
+
-
MT48LC2M32B2TG-6 MT 200 04+
+
-
MT48LC4M16A2TG-8E MT 60 01+
+
-
MT48LC8M16A2TG-7E MT 700 01+
+
-
MT48LC8M16A2TG-75 MT 600 03+
+
-
MT48LC16M16A2TG-75 MT 1000 04+
+
-
MT48LC4M32B2TG-7 MT 120 03+
+
-
M29W160DT-90N1 ST 300 02+
+
-
MX29F400BTC-90 MX 768 00+
+
-
MT9V111 MT9M001 MT9M011 MT9D001 MT9T001
+
-
MT9V011(MI360) MT9V011  MT9V403 MT9V111
+
-
MT9T001 MT9M413 MT9M111 MT9M011 MT9V111
+
-
MT9M001C12STC MT9M001  MT9V011
+
-
MT9V011 MT9M001 MT9D001 MT9T001
+
-
OV7910 OV2610 OV3610 OV9620 OV7910
+
-
OV7411 OV5116 
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
Hynix
+
-
 
+
-
SDRAM   
+
-
HY57V561620CT-H 16Mx16SDRAM 10K/04+ 960
+
-
HY57V56420CT-H-A 64M*4SDRAM 5760/04+ 960
+
-
HY57V561620CTP-H 16M*16SDRAM 5760/04+ 960
+
-
HY57V56820CT-H 32M*8SDRAM 10k/04+ 960
+
-
HY57V561620CLT-H  16M*16SDRAM 20K/05+ 960
+
-
HY57V281620HCT-H 8Mx16SDRAM 20K/04+ 960
+
-
HY57V281620ET-6 8Mx16SDRAM 10K/04+ 960
+
-
HY57V281620ET-H 8Mx16SDRAM 10K/04+ 960
+
-
HY57V641620HGT-H 4Mx16SDRAM 30K/04+ 960
+
-
HY57V641620HGTP-H 4M*16SDRAM 15K/04+ 960
+
-
HY57V641620HGT-7 4Mx16SDRAM 20k/04+ 960
+
-
HY57V641620HGT-6 4Mx16SDRAM 7K/03+ 960
+
-
HY57V641620ET-7 4Mx16SDRAM 50K/04+ 960
+
-
HY57V641620ET-H 4Mx16SDRAM 10K/04+ 960
+
-
HY57V641620ET-6 4Mx16SDRAM 11520/05+ 960
+
-
HY57V643220DT-6 2M*32SDRAM 10k/04+ 960
+
-
HY57V64820HGLT-PDR 8M*8SDRAM 10K/04+ 1000/reel
+
-
HY57V161610ETP-7 1Mx16SDRAM 50K/04+ 960
+
-
HY57V161610ET-7 1Mx16SDRAM 50K/04+ 960
+
-
 
+
-
 
+
-
 
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
 
+
-
 
+
-
 
+
-
P2S56D20BTP-6 UTT UTT - Mira
+
-
V58C2256804SAT-6 Mosel Vitelic
+
-
M2S56D30ATP-60 Mitsubishi
+
-
HYB25D256160BT-6 Infineon
+
-
EDD2516AMTA-6B Elpida
+
-
EDD5116ADTA-7A Elpida
+
-
HYB25D256400BT-7 Infineon
+
-
EDD2508AKTA-7A Elpida
+
-
HYB25D128800AT-7 Infineon
+
-
N2SV25616BS-75B Elixir
+
-
HYB39S256160DTL-7 Infineon
+
-
HYB39S256160DT-7 Infineon
+
-
HYB39S128400CT-7.5 Infineon
+
-
HYB39S128800CT-7.5 Infineon
+
-
HYB39S256400DT-7 Infineon
+
-
HYB39S256800DT-7 Infineon
+
-
HYB25D256800BT-6 Infineon
+
-
HYB25D256800CE-6 Infineon
+
-
UPD45128163G5-A75 NEC Singapore
+
-
UPD45128163G5-A75SU-9JF NEC Japan
+
-
UPD45128163G5-A75-9JF Elpida
+
-
UPD45128163G5-A75TI-9JF Elpida
+
-
UPD45128163G5-A75LI-9JF Elpida
+
-
EDS1216AATA-75 Elpida
+
-
HYB39S128160CT-7 Infineon
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
S16008LK9TW-75AG Spectek
+
-
EDS1232AATA-75 Elpida
+
-
NT5SV4M16DT-7K Nanya
+
-
GLT5640L16-7TC G-link
+
-
S16004LK6TW-75AG Spectek
+
-
GLT5640L32-6TC G-Link
+
-
TC59S6432CFT-70 Toshiba
+
-
EC001164VS OEM ACE
+
-
EM636165TS-6G Etron
+
-
EM636165TS-7 Etron
+
-
IC42S16100-7T ICSI
+
-
IC42S16100-6T ICSI
+
-
T436416A-7S OEM TM
+
-
IS42S16800A-7T ISSI
+
-
UPD45128441G5-A10 NEC
+
-
UPD4516421AG5-A10-9NF NEC
+
-
NT511740D5J-60S Nanya
+
-
NT511740D5J-60 Nanya
+
-
TC5117805CJ-60 Toshiba
+
-
AS4LC1M16E5-60JC Alliance
+
-
AS4LC1M16E5-60JI Alliance
+
-
M11B416256A-25J Elite MT
+
-
HY512264TC-60 Hynix
+
-
TC51V18160CFTS-60 Toshiba
+
-
MSM514400DL-60SJ OKI
+
-
HM5116400S-6 Hitachi
+
-
 
+
-
IC库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
SST
+
-
 
+
-
SST39VF010-70-4C-NH SST 25000 02+ 5days
+
-
SST39VF010-70-4C-WH SST 25000 02+ 5days
+
-
SST39VF020-70-4C-NH SST 30000 02+ 5days
+
-
SST39VF040-70-4C-NH  SST 50000 03+ 3days
+
-
SST39VF088-70-4C-EK SST 20000 03+ 3days
+
-
SST39VF200A-70-4C-B2K SST 3325 01+ STOCK
+
-
SST39VF400A-70-4C-EK SST 30000 03+ 3days
+
-
SST39VF800A-70-4C-BK SST 4000 02+ STOCK,2K/box
+
-
SST39VF800A-70-4C-EK SST 20000 03+ 3days
+
-
 
+
-
 
+
-
 
+
-
 
+
-
 
+
-
C库存,低价清仓!!Over 100000 units in stock !!!
+
-
 
+
-
Please contact with me if you have them available .
+
-
Regards
+
-
***********************************
+
-
ShenZhen Fuda Electronic Ltd
+
-
Eric Liu
+
-
T: 86-755-89800951
+
-
F: 86-755-88850695
+
-
Email:sales56@gmail.com
+
-
NSN:sales81@hotmail.com
+
-
***********************************
+
-
 
+
-
 
+
-
+
when I run this query, I have the following plan:
when I run this query, I have the following plan:

在2006年2月1日 (三) 13:21的最新修訂版本

如何改善 joins and order by 的執行效率

  • 問題描述

Hi

I'm looking for a solution, to get better performance with the following query

select first 25 RI.PLACE, SR.SWIMTIME, A.LASTNAME from RANKINGITEM RI join SWIMRESULT SR on SR.SWIMRESULTID = RI.SWIMRESULTID join ATHLETE A on A.ATHLETEID = SR.ATHLETEID where RI.RANKINGID = 589044 order by RI.PLACE

when I run this query, I have the following plan: PLAN SORT (JOIN (RI INDEX (IX_RANKINGITEM_WORLD),SR INDEX (PK_SWIMRESULT),A INDEX (PK_ATHLETE)))

when I look ath the statistics I have 33'000 indexed accesses to all three tables.

When I remove the "order by" part, the query is much faster and I have 25 indexed accesses to the three tables only.

The plan is: PLAN JOIN (RI INDEX (IX_RANKINGITEM_WORLD),SR INDEX (PK_SWIMRESULT),A INDEX (PK_ATHLETE))

What I don't understand is, why Firebird server reads all 33'000 records in all tables, even if the "order by" depends on RANKINGITEM only and there is an index for that on RANKINGITEM.

Anything I can do here with a query plan or something else ?

cu Christian

  • 解決方式

The Query with the ORDER BY (SORT in PLAN) first fetch all results internally and perform a sort on the results. After that only 25 records are returned to the client. The Query without ORDER BY doesn't need to perform a sort, so it just returns the first 25 valid records fetched from disk.

If you really need a fast behaviour for this you can create a single index on RI.PLACE, but probably better is a compound index on RANKINGID, PLACE and but it in the same order in the ORDER BY clause.

Regards, Arno Brinkman ABVisie