MySQL Forums
Forum List  »  Newbie

Re: Rewrite Full Outer Join into Subquery
Posted by: Rick James
Date: October 12, 2014 04:00PM

I see a `dim_date`, but not a `dim_dates`.

The CREATE TABLE for S_orders is missing a lot of fields.

You have not indexes; hence the queries will be slow.

Use InnoDB, not MyISAM.

Do not have tables with just one column, unless you can justify it.

How are the `..._id` fields set? Are they AUTO_INCREMENT, but that was not mentioned?

Options: ReplyQuote


Subject
Written By
Posted
Re: Rewrite Full Outer Join into Subquery
October 12, 2014 04:00PM


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.