Home » RDBMS Server » Performance Tuning » driving table and join order (12c)
driving table and join order [message #674208] Thu, 10 January 2019 13:41 Go to previous message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
i am trying to learn sql query optimization basics,can anyone explain what is the driving table in sql and how the optimizer decides on join order with some example.
what i understand is the table which has less rows will be chosen as driving table because the less rows it has the access is simpler. I am not getting this concept very clear.
 
Read Message
Read Message
Read Message
Previous Topic: table Partition when values are unknown
Next Topic: RELY constraints
Goto Forum:
  


Current Time: Thu Mar 28 15:55:58 CDT 2024