Re: update index ...

2002-01-10 Thread Girish Nath
uot;Chuck Lidderdale" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 6:19 PM Subject: update index ... > Did the create table several months ago. > Did a create index idx_abc on tableA.. > Have added lots of data - lots of data . >

update index ...

2002-01-10 Thread Chuck Lidderdale
Did the create table several months ago. Did a create index idx_abc on tableA.. Have added lots of data - lots of data . Back when I worked with Informix I would run "update statistics for tableA " which would recreate the index - et-al. Now I'm using Mysql - do I need to do anythin