Jointure sans index On force ici loptimiseur à ne pas utiliser lindex de sales set timing on set autotrace trace SELECT /*+ NO_INDEX(s) */ serialNo, m
{"Image DocumentName": "Jointure sans index On force ici l\u2019optimiseur \u00e0 ne pas utiliser l\u2019index de sales", "Image ImageDescription": "set timing on set autotrace trace SELECT / + NO_INDEX(s)  / serialNo, model, color FROM Autos A, Sales s WHERE serial = serialNo; Ecoul\u00e9 : 00 :00 : Plan d ex\u00e9cution | Id | Operation | Name | Rows| Bytes | Cost | | 0 | SELECT STATEMENT | | 236 | 5428 | 4 | | 1 | NESTED LOOPS | | 236 | 5428 | 4 | | 2 | TABLE ACCESS FULL | SALES | 236 | 1416 | 3 | | 3 | TABLE ACCESS BY INDEX ROWID | AUTOS | 1 | 17 | 1 | | 4 | INDEX UNIQUE SCAN | PK_AUTOS | 1 | | 0 |", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}