Re: Index creation problem

dllewell@dimensional.com (Daniel Llewellyn) wrote: : The problem has occured twice now. The first time I dropped the table :and recreated it. That fixed the problem, I could then create the new :index. It has happened a second time now , however, and I don't want :to have to drop the table and recreate it every couple of weeks. One small thing I forgot: Why do you have to do this creation of indexes all the time? Our installations are running for years without touching this kind of thing. If you are deleting a lot of rows all the time you might perhaps see some performance improvment, but otherwise you might simply leave the index untouched? Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company