RE: INSERT speed

[Dan Goldberg]

Not that I noticed. If you have a rule(s) applied to that table and you don't need it for that particular operation then turn rules off before running that operation.   Example   set rules off INSERT INTO table (column) VALUES (.varusername) set rules on -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of William Mason Sent: Monday, July 16, 2001 3:11 PM To: [EMAIL PROTECTED] Subject: INSERT speed Does anyone know if there is an appreciable speed difference in INSERTing straight values versus using expressions?  For example, does   INSERT INTO table (column) VALUES (.varusername)   run faster than   INSERT INTO table (column) VALUES (CVAL'User'))?   TIA