ben elle est pas claire au dessus ou la :
Par défaut
Citation:
Sans explain plan ça va pas beaucoup nous aider ta requête
Plan
SELECT STATEMENT CHOOSECost: 175,576 Bytes: 3,902,860 Cardinality: 22,958
16 SORT GROUP BY Cost: 175,576 Bytes: 3,902,860 Cardinality: 22,958
15 HASH JOIN Cost: 174,468 Bytes: 3,902,860 Cardinality: 22,958
1 TABLE ACCESS FULL EXPL.BO_FAMILLE Cost: 2 Bytes: 690 Cardinality: 30
14 HASH JOIN Cost: 174,464 Bytes: 3,374,826 Cardinality: 22,958
2 TABLE ACCESS FULL EXPL.BO_SOUS_FAMILLE Cost: 2 Bytes: 9,594 Cardinality: 369
13 NESTED LOOPS Cost: 174,459 Bytes: 2,777,918 Cardinality: 22,958
11 HASH JOIN Cost: 174,459 Bytes: 2,640,170 Cardinality: 22,958
9 HASH JOIN Cost: 173,128 Bytes: 1,469,312 Cardinality: 22,958
7 HASH JOIN Cost: 7 Bytes: 380 Cardinality: 10
5 INLIST ITERATOR
4 TABLE ACCESS BY INDEX ROWID EXPL.BO_SUCCURSALE Cost: 2 Bytes: 96 Cardinality: 4
3 INDEX RANGE SCAN UNIQUE EXPL.PK_BO_SUCCURSALE Cost: 1 Cardinality: 4
6 TABLE ACCESS FULL EXPL.BO_PVT Cost: 4 Bytes: 1,064 Cardinality: 76
8 TABLE ACCESS FULL EXPL.STATARTICLE Cost: 173,099 Bytes: 35,813,830 Cardinality: 1,377,455
10 TABLE ACCESS FULL EXPL.BO_ARTICLE Cost: 347 Bytes: 18,255,297 Cardinality: 357,947
12 INDEX UNIQUE SCAN UNIQUE EXPL.PK_BO_SECTION Bytes: 6 Cardinality: 1j ai pas le temps ce soir
j'essayerai demain
sinon voir mon fichier joint il y a tout dessus
Partager