MySQL Forums
Forum List  »  Performance

Re: select query not using indexes
Posted by: Rick James
Date: June 21, 2008 05:56PM

If your table is big, disk I/O is a bigger factor than any benefits of "fixed" size rows. Use VARCHAR unless your values are really fixed size.

I had forgotten about the ORDER BY NULL trick :)

Options: ReplyQuote


Subject
Views
Written By
Posted
4022
June 11, 2008 01:05AM
1929
June 11, 2008 04:44AM
1918
June 15, 2008 07:44PM
2005
June 16, 2008 06:45PM
Re: select query not using indexes
1831
June 21, 2008 05:56PM
1729
June 23, 2008 11:49PM
2147
June 27, 2008 11:23PM
1892
June 18, 2008 08:22AM


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.