10 questions on MySQL speed-up and optimizations

Category: Database Questions    |    3 views
  1. Which will be faster out of these two queries - one with OR or one with IN?
  2. Where does MyISAM cache table records?
  3. Which will be faster out of queries with explicit INNER JOIN and implicit one?
  4. Is InnoDB faster/better than MyISAM?
  5. Is CHAR faster than VARCHAR?
  6. Is VARCHAR(80) faster than VARCHAR(255)?
  7. Are there performance issues when joining tables from different storage engines?
  8. If I change a derived table to a view, will performance increase?
  9. If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
  10. Is it possible to do a FULL OUTER JOIN in MySQL?

Share/Save/Bookmark

1 Star2 Stars
Loading ... Loading ...

Tags: ,

0 responses so far!

Leave a Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word