Simple performance question regarding INSERT statement

Let's say you have a table:

CREATE TABLE products
(

prod_id       int(10),
prod_name     varchar(30),
prod_desc     varchar(100),
prod_category varchar(10),
active        boolean

Is performance affected if the columns in your INSERT statements are not in-line with the CREATE TABLE declarations. For example,

--Column list out of order
INSERT INTO products (active, prod_id, prod_category, prod_desc, prod_name)
VALUES (TRUE, 100001, 'Outdoor', 'Best Lawnmower Available', 'Lawnmower');

Let's say you were going to do 100,000 INSERTS at one time. Will performance be degraded, and to what degree? Received on Fri Nov 12 2004 - 09:35:11 CST