SELECT query to see if index scans are being used
where possible?
-Mitch
- Original Message -
From: "Rini Dutta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 25, 2000 12:20 PM
Subject: [SQL] queries and inserts
>
Hi,
I am interested in how to speed up storage. About 1000
or more inserts may need to be performed at a time ,
and before each insert I need to look up its key from
the reference table. So each insert is actually a
query followed by an insert.
The tables concerned are :
CREATE TABLE referencet
