1. salah satunya bisa index. tapi pake index kalo tidak dipake ya sama aza. Jadi harus diliat column mana yang harus diindex. 2. Query nya tidak optimal, coba periksa kembali. Sebaiknya filter (where) columnya yang ditembak diletakkan diatas jadi sudah terfilter dahulu sebelum query dengan table lain.
--- Abun <[EMAIL PROTECTED]> wrote: > > To : All Expert PB.. > > > Aku punya data : di sql 2000 > master : 400-an row > detail : 1 juta an row > > Pertanyaan : > 1. Kenapa pada dw (retrieve) nya lama ??? > 2. Apa perlu buat index nya ??? bagaimana caranya > ??? > > computer : pentium 4 2 ghz, harddisk 40 gb, ram=128 > > pake windows 98se . > > Tolong bantuan informasinya.. > > Terima kasih > > > > > [Non-text portions of this message have been > removed] > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > $9.95 domain names from Yahoo!. Register anything. > http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/NhFolB/TM > --------------------------------------------------------------------~-> > > > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: > [EMAIL PROTECTED] > Yahoo! Groups Links > > > [EMAIL PROTECTED] > > > > > > __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
