This is the TABLE ACCESS FULL of the COLOURS table. Start from the top ( SELECT STATEMENT) and go down the tree to the first leaf. select *įrom table(dbms_xplan.display_cursor(:LIVESQL_LAST_SQL_ID)) After reading, this, pass the rows back up to its parent. Travel down the plan to find the next unvisited leaf. After reading the data from this source, it goes back up to its parent.Īt this point the process repeats. This starts from the SELECT operation at the top of the plan. The database uses depth-first search to traverse it. Insert into pens values ( 'blue', 'dry-wipe' ) Įxec dbms_stats.gather_table_stats ( null, 'pens' ) Įxec dbms_stats.gather_table_stats ( null, 'colours' ) Įxec dbms_stats.gather_table_stats ( null, 'bricks' ) Įxec dbms_stats.gather_table_stats ( null, 'cuddly_toys' ) Īn execution plan is a tree. Insert into pens values ( 'blue', 'permanent' ) Insert into pens values ( 'red', 'dry-wipe' ) Insert into pens values ( 'red', 'permanent' ) Insert into pens values ( 'green', 'dry-wipe' ) Insert into pens values ( 'green', 'permanent' ) Insert into pens values ( 'blue', 'ball point' ) Insert into pens values ( 'black', 'permanent' ) Insert into pens values ( 'black', 'ball point' ) Insert into bricks values ( 'green', 'cube' ) Insert into bricks values ( 'blue', 'cube' ) Insert into bricks values ( 'red', 'cylinder' ) Insert into colours values ( 'green', '00FF00' ) Insert into colours values ( 'blue', '0000FF' ) Insert into colours values ( 'red', 'FF0000' ) Insert into cuddly_toys values ( 'White Rabbit', 'white' ) Insert into cuddly_toys values ( 'Green Rabbit', 'green' ) Insert into cuddly_toys values ( 'Baby Turtle', 'green' ) Insert into cuddly_toys values ( 'Cuteasaurus', 'blue' ) Insert into cuddly_toys values ( 'Miss Snuggles', 'pink' )
0 kommentar(er)
