Subject more efficient filter
Author Alex Castillo
Hello,

I've seen on different database designs two main filters approaches in order to select based on a "status" field: a status based on char(1) and status based on number.

For example,

1rst approach:
SELECT * FROM table WHERE status = 'A'

2do approach:
SELECT * FROM table WHERE status = 1

The question is: What approach is the best in order to improve query performance??

Best regards,

_______________________________
I'm free, I use GNU/Linux.
Close your Windows, Open your mind.

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¬°gratis!
Regístrate ya - http://correo.yahoo.com.mx/