Re: Simple performance question regarding INSERT statement

Russ Reynolds wrote:

> 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?

FOR i IN 1 .. 100000
LOOP
   <try it>
END LOOP;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)