A clustered index is one that is typically unique and thus why primary keys are typically clustered indexes. You will typically have one of those per table that could span multiple columns.
Your non-clustered are not meant to be unique, but a way to order data to make foreign key joins quicker. Teddy On 2/19/07, stylo stylo <[EMAIL PROTECTED]> wrote: > > I don't know what a clustered index is, sorry. > > I have read that mysql indexes the primary keys so doing so again is > redundant. > > I've come to the conclusion that the migration toolkit is terrible. It not > only does the yes/no's wrong, it doesn't get required fields or default > values! As it didn't do those right, or advertise it, I'm worried about > other things too. > > I've tried access2mysql and access to mysql. Both seem ok in demos. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2738 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
