|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Indexing and no values
From: Gleb Paharenko (gleb.paharenko
ensita.net)
Date: Mon Oct 03 2005 - 04:30:22 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 values, to leave it blank ('') or to insert a '0'/'NULL'?
>
> Thnx,
>
> Lefteris
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]