MySQL Forums
Forum List  »  InnoDB

using enum as means of compression
Posted by: postaholic066 SQL
Date: March 28, 2010 09:40AM

I was looking for various ways I could compress data in my MySQL database.
- Creating lookup tables
- using enums
Is there some other solution?

Sticking to enums...
I am doubtful about how does InnoDB execute the following where clause containing an enum column named 'colFoo' in a table named 'foo'?

" SELECT ... FROM foo WHERE colFoo = 'someString' "
Would it scan the table if 'someString' is not in the enum declaration?

Options: ReplyQuote

Written By
using enum as means of compression
March 28, 2010 09:40AM

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.