Hello.
> What's the reason behind this?
If you're asking about why I've written that columns defined as NOT NULL
are faster - I've read it in one of the articles from dev.mysql.com.
I'm not sure about the true reason, but the way MySQL stores NULLs
is strongly dependent on the storage engi
Gleb Paharenko wrote:
I'm not giving an exact answer on your question, however, it might be
interesting for you. Usually queries are faster if you define the column as NOT
NULL.
What's the reason behind this? NULL 'values' are a bit of strange
phenomenon. In the EXPLAIN output a query with WH
Hello.
I'm not giving an exact answer on your question, however, it might be
interesting for you. Usually queries are faster if you define the column as NOT
NULL.
Lefteris Tsintjelis wrote:
> Hi,
>
> What is better/faster to insert as a value for indexed fields, in case of
> 0 or Null
