just wanted to see if you guys can help me out on this. I have attached a pic. When i get the plan for my query...and i right click on the HIGHLIGHTED (yellow part) and click on " get help on INDEX FULL SCAN " ...its not just index full scan...anything as a matter of fact...HASH JOINs, nested loops....Just trying to learn new things...also just and FYI, i do have the Knowledge Xpert for Oracle Administration and...Knowledge Xpert for PLSQL...do i need some other module to run that part..as its very helpful feature to learn new stuff...do i have a wrong setting or ???
this is inside SQL OPTIMIZER…
Message was edited by: crazy