MySQL Forums
Forum List  »  Data Warehouse

foreign keys in star schema
Posted by: Andrea Torre
Date: July 06, 2009 09:26AM

Hi, I am developing a data warehouse solution using InnoDB. I read about the speed superiority of MyIsam for data wh purpose, but I am quite new of this matter and don't feel confident enough to abandon the foreign key constraints that seem very important in the kimball's star schema. What do you think about it?

Many thanks in advance for your comments.

//andrea

Options: ReplyQuote


Subject
Views
Written By
Posted
foreign keys in star schema
8464
July 06, 2009 09:26AM
4634
July 07, 2009 09:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.