Hi Mike, i have noticed that things take a lot longer if they aren't surrounded by a BEGIN; do work; COMMIT;
does that make a difference for you? Paul On 09/08/07, mos <[EMAIL PROTECTED]> wrote: > I'm building my first index on a large table using the "Create index > ix_Main on Table1(StringField1,StringField2,DateField,TimeField)" and so > far it has been running over an hour on a fast computer with 2gb ram. There > are 15 million rows in the table. The same index can be built in MySQL in a > minute or two. Why does it take so long? > > Mike > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------