138 reputation
15
bio website bazzilic.me
location Singapore
age 25
visits member for 2 years, 9 months
seen Jan 19 at 3:03
  • 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.

Jun
9
awarded  Notable Question
Jul
17
awarded  Popular Question
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