RE: 4 days to drop Index

The first thing to check is either that your key_buffer_Size is too small (if it's a myisam table) or your innodb_buffer_pool_size is too small (if it's a innodb table). After that, most of the time for alter table depends on disk IO. On decent hardware a rate of 4G/hr is common, so around 6 h

Re: join query for sale report

any suggestion, for my question plz On Fri, Dec 24, 2010 at 10:57 PM, bharani kumar < bharanikumariyer...@gmail.com> wrote: > I want to take the sale report, > > Group by catID , > > Daily report , > > table name : tblbasket BID Auto Incre, Prim Key > > BID int(20), BasketSessionID varc