2 SQL
=INSERT INTO t1 VALUES
(?
, ?
, 'CSQL'); hits
=0 inuse
=0
8 After reusing cached insert stmt
10 SQL
=INSERT INTO t1 VALUES
(?
, ?
, 'CSQL'); hits
=0 inuse
=0
12 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT
, f3 VARCHAR
(20));
13 CREATE INDEX t1_idx1_Primary on t1
( f1
) HASH UNIQUE
;
14 INSERT INTO t1 VALUES
(1,1, 'First');
15 INSERT INTO t1 VALUES
(2,1, 'Second');
16 INSERT INTO t1 VALUES
(3,1, 'Third');
17 INSERT INTO t1 VALUES
(4,1, 'Fourth');
18 INSERT INTO t1 VALUES
(5,1, 'Fifth');
19 INSERT INTO t1 VALUES
(100,100, 'CSQL');
20 INSERT INTO t1 VALUES
(200,200, 'CSQL');
21 ---------------------------------------------------------
23 ---------------------------------------------------------
26 ---------------------------------------------------------
28 ---------------------------------------------------------