Yang saya coba ada 6 field ngak ada index, ngak ada primary key . jml record 100100. Perintah : select count(nilai) from contoh where umur >1 and umur<100000; Hasil IB Console Statistic: Execution Time : 00:00:00.0401
Perintah : select sum(nilai) from contoh where umur >1 and umur<100000; Hasil IB Console Statistic: Execution Time : 00:00:00.0420 CMIIW - Ujok ----- Original Message ----- From: "arif rahman" <[EMAIL PROTECTED]> To: "Bayu" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 6:20 PM Subject: Re[2]: [Delphindo] (OOT) fungsi aggregate firebrid lambat > struktur tabelnya sbb: > tabel test > nomor integer -> primary key > nama char(500) > alamat char(500) > > jumlah data 110000 > > perintah yang digunakan adalah: > select count(nomor) from test where nomor>1 and nomor<100000; > > hasil statistiknya (IB Console) sbb: > Execution Time -> 1.13 menit ---------------------------------------------------------------------------- Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai ---------------------------------------------------------------------------- Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
