using enum as means of compression
Hi,
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?
Subject
Views
Written By
Posted
using enum as means of compression
3896
March 28, 2010 09:40AM
1429
March 29, 2010 10:47PM
1386
April 02, 2010 02:27AM
1279
April 02, 2010 06:41AM
1254
April 03, 2010 12:54AM
1330
April 02, 2010 07:32PM
1453
April 03, 2010 01:10AM
2248
April 03, 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.