SQL INSERT performance omitting field names?
Posted
by Marco Demaio
on Stack Overflow
See other posts from Stack Overflow
or by Marco Demaio
Published on 2010-03-24T18:20:53Z
Indexed on
2010/03/24
18:23 UTC
Read the original article
Hit count: 227
Filed under:
sql
|Performance
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.
© Stack Overflow or respective owner
