Mark kirkwood ([EMAIL PROTECTED]) writes:
> CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
>
> Whichunfortunatly takes about 20m ( which I think is a bit slow )
Have you tried building the table structure with the index already in place,
then importing the data?
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
