(Kyle Hailey) How do you determine if the Oracle SQL optimizer has created a sub-optimal execution plan? re-run statistics and see what happens? wait for Oracle to fin other execution plans? What if neither method is helping? Do you read the execution plan? What do you look at?
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help