network profile
| bio | website | bazzilic.livejournal.com |
|---|---|---|
| location | Singapore | |
| age | 24 | |
| visits | member for | 1 year, 7 months |
| seen | Sep 24 '12 at 10:00 | |
| stats | profile views | 3 |
- Masters degree in Math & Computer Science, 2006–2011 — Moscow State University, Moscow, Russia.
- Masters degree in Management & Human Resources, 2009–2011 — Moscow State University, Moscow, Russia.
- Ph.D. in Computer Science, 2011–... — Nanyang Technological University, Singapore.
|
Sep 17 |
awarded | Autobiographer |
|
Sep 17 |
comment |
Does creating an index on BIT(n) attribute in MySQL make sense? Thanks for this detailed answer! Yes, I understand that b-tree won't be able to help in searching values by predicate containing bitwise operations. I was though unsure how MySQL stores BIT attrs in InnoDB (sorry, I forgot to mention I am using InnoDB) and does it affect indexing or not. In fact, according to your answer, it appears that using BIT instead of other numeric types has the only advantage - convenience if you need a number of bits other than power of 2. |
|
Sep 17 |
accepted | Does creating an index on BIT(n) attribute in MySQL make sense? |
|
Sep 16 |
awarded | Supporter |
|
Sep 16 |
asked | Does creating an index on BIT(n) attribute in MySQL make sense? |
|
Oct 26 |
awarded | Student |
|
Oct 26 |
comment |
Transact SQL using WITH in CREATE VIEW Thanks, gbn! I should have read it more careful! |
|
Oct 26 |
accepted | Transact SQL using WITH in CREATE VIEW |
|
Oct 26 |
awarded | Scholar |
|
Oct 26 |
asked | Transact SQL using WITH in CREATE VIEW |
