Re: Creating Indices on SE

I have not had your problem, but I'll take a shot at it anyway. To the best of my knowledge, ALTER TABLE creates a second copy of the table, including rebuilding all existing indices. This should produce a slightly cleaner index structure than a simple CREATE INDEX statement, which will leave all existing indices alone. Someone please correct me if I am wrong. John Prideaux alastl@ix.netcom.com Syd Stewart wrote: > > When creating indices using the CREATE command we have found a > significant performance degradation. Is this the case or have I done > something wrong. When idices are created using the Alter table command > the performance is significantly better. I used named indices with > the CREATE command. Has anyone have any experience of this please. > --