Bonjour,
Je suis entrain de faire des tests de performance sur une base de donnée installée sur ASE 12.5.4. actuellement, j'ai fait un set showplan on et un set fmtonly on sur une procedure stockée qui insert 3615000 de lignes .
je souhaite que quelqu'un m'explique que signifie les resultats ci-dessous car je n'ai pas beaucoup de connaissance sur l'interpretation de showplan:
set showplan on
go
set fmtonly on
go
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is EXECUTE.
QUERY PLAN FOR STATEMENT 1 (at line 0).
STEP 1
The type of query is DECLARE.
QUERY PLAN FOR STATEMENT 2 (at line 3).
STEP 1
The type of query is COND.
QUERY PLAN FOR STATEMENT 3 (at line 5).
STEP 1
The type of query is INSERT.
The update mode is direct.
FROM TABLE
PERSONNE
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Mytable
Using I/O Size 2 Kbytes for data pages.
QUERY PLAN FOR STATEMENT 4 (at line 7).
STEP 1
The type of query is SELECT.
QUERY PLAN FOR STATEMENT 5 (at line 0).
STEP 1
The type of query is GOTO.
QUERY PLAN FOR STATEMENT 1 (at line 0).
STEP 1
The type of query is DECLARE.
QUERY PLAN FOR STATEMENT 2 (at line 3).
STEP 1
The type of query is COND.
QUERY PLAN FOR STATEMENT 3 (at line 5).
STEP 1
The type of query is INSERT.
The update mode is direct.
FROM TABLE
PERSONNE
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Mytable
Using I/O Size 2 Kbytes for data pages.
QUERY PLAN FOR STATEMENT 4 (at line 7).
STEP 1
The type of query is SELECT.
QUERY PLAN FOR STATEMENT 5 (at line 0).
STEP 1
The type of query is GOTO.
(return status = 0)
Cordialement.
Partager