rrey2279_at_aol.com (Russ Reynolds) wrote in message news:<2a73e567.0411120735.a80672_at_posting.google.com>...
> 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?
The few cpu cycles that it will take Oracle to put the values in the
correct columns will not make any difference, till you are talking
Millions or rows, and a table with the max number of columns.
Received on Fri Nov 12 2004 - 13:51:05 CST
