SQL INSERT performance omitting field names?
- by Marco Demaio
Does anyone knows if removing the field names from an INSERT query results in some performance improvements?
I mean is this:
INSERT INTO table1 VALUES (value1, value2, ...)
faster for DB to be accomplished rather than doing this:
INSERT INTO table1 (field1, field2, ...) VALUES (value1, value2, ...)
?
I know it might be probably a meaningless performance difference, but just to know.
