I rerezad you and discovered that (BrgId, Kode) is UNIQUE. your query will return no rows :o)
spending 54813 ms for nothing. Mathias Selon [EMAIL PROTECTED]: > Hi, > You may have the same table structure in MS, but not the same table definiton > : > constraints+indexes+stats ! > > try : > create index toto on Barang(BrgId, Kode, Barang); > Select BrgId, Kode, Barang From Barang > Group By Barang > Having Count(*) > 1 ; > > Mathias > > Selon Hendro Suryawan <[EMAIL PROTECTED]>: > > > Hi, > > I have 8414 records in table name Barang, I run query like this : > > > > Select BrgId, Kode, Barang From Barang Where Barang in > > (Select Barang From Barang Group By Barang Having Count(*) > 1 ) > > > > and the answer took 54813 ms. I think is too long. I ran the same query > > against same table in MS SQL Server it took 1 second. Does anyone have > > any idea? > > > > I have mysql on FC 3 X86_64 on Athlon 64, RAM 512 MB. > > Table Definition : > > CREATE TABLE `Barang` ( > > `BrgId` int(4) NOT NULL default '0', > > `Kode` varchar(11) NOT NULL default '', > > `Barang` varchar(70) NOT NULL default '', > > `Satuan` varchar(10) default NULL, > > `Stok` decimal(10,0) default NULL, > > `Nilai` decimal(10,0) default NULL, > > `Lokal` char(1) default NULL, > > `SGrupId` int(10) NOT NULL default '0', > > `StokMin` int(10) default NULL, > > `Catatan` blob, > > `Benda` char(1) NOT NULL default '', > > `Gambar` longblob, > > `LastTrans` date default NULL, > > `Operators` varchar(50) default NULL, > > PRIMARY KEY (`BrgId`), > > UNIQUE KEY `Kode` (`Kode`), > > KEY `Barang` (`Barang`) > > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > > > > > thanks, > > Hendro > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
