> > > > Shows us the explain analyze. There is no problem with a large number > of records, as long as you're not expecting to process all of them all > the time.
yes many a times i need to process all the records, often i need to use count(*) ???? so what to do ?? ( those trigger options i know already, but i wil l do count on different parameters ) > > >