Search code examples
mysqlreserved-words

MySQL - Can using reserved words as table names decrease performance?

I know that doing something like this would be considered bad practice but if one were to create a table with fields like from, to, desc and did:

SELECT *

or 

SELECT `from`, `to`, `desc`

With a massive data / result set would this have any kind of performance difference as opposed to using names like sent_from, sent_to, description?

Solution

  • I don't think there will be any or rather any significant difference in the performance if you are using reserved keywords as table name. The only thing which you will get and which you are already aware of, is the readability and the poor design of database.