1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
SELECT Dept_rayon.iddepartement_rayon AS iddepartement_rayon , Dept_rayon.Memo_structure AS Memo_structure , Departement.IDdepartement AS IDdepartement , Departement.Departement AS Departement , Rayon.IDRayon AS IDRayon , Rayon.libelle_rayon AS libelle_rayon , Dept_rayon.idholding AS idholding , Dept_rayon.idsociete AS idsociete , Dept_rayon.IDenseigne AS IDenseigne , Dept_rayon.IDEnseigne_departement AS IDEnseigne_departement , Affect_Achet.IDacheteur AS IDacheteur
FROM Departement , Dept_rayon , Rayon , Enseigne_depart , Affect_Achet
WHERE ( ( ( ( Departement.IDdepartement = Dept_rayon.IDdepartement ) AND ( Rayon.IDRayon = Dept_rayon.IDRayon ) ) AND ( Enseigne_depart.IDEnseigne_departement = Dept_rayon.IDEnseigne_departement ) ) AND ( Affect_Achet.iddepartement_rayon = Dept_rayon.iddepartement_rayon ) )
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 1.72 1.72 6 314 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 1.72 1.72 6 314 0 0
SELECT ALL_IND_COLUMNS.INDEX_NAME, ALL_IND_COLUMNS.COLUMN_NAME,
ALL_IND_COLUMNS.COLUMN_POSITION, ALL_INDEXES.UNIQUENESS
FROM
SYS.ALL_IND_COLUMNS,SYS.ALL_INDEXES WHERE ALL_IND_COLUMNS.INDEX_NAME=
ALL_INDEXES.INDEX_NAME AND ALL_IND_COLUMNS.INDEX_OWNER=ALL_INDEXES.OWNER
AND ALL_IND_COLUMNS.TABLE_OWNER='magali' AND ALL_IND_COLUMNS.TABLE_NAME=
'Magali_service' ORDER BY INDEX_NAME,COLUMN_POSITION DESC
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 34 0.60 0.61 0 8 0 0
Execute 17 0.00 0.00 0 0 0 0
Fetch 17 0.00 0.00 0 17 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 68 0.60 0.61 0 25 0 0 |
Partager