MySQL Forums
Forum List  »  InnoDB

Re: taking long time to ALTER the table
Posted by: Ra Nala
Date: April 18, 2016 03:54AM

Rick James Wrote:
-------------------------------------------------------
> Build and maintain Summary Tables for Data Warehousing.They can be denormalized.

Not sure if you are taking about Fact table (i.e summary tables) and we are maintaining it with STAR schema which is designed based on Inmon theory.

> Doing that, you will have less need for this monstrosity.
dimensions table(i.e descriptive tables) which touches to the fact and will retrieve the data fast.

Options: ReplyQuote


Subject
Views
Written By
Posted
1131
April 07, 2016 07:47AM
Re: taking long time to ALTER the table
544
April 18, 2016 03:54AM


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.