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 ???
I am not sure why this feature is not working for you. After you have right-clicked on the yellow highlighted step in the execution plan and selected “Get help on …”, look at the Windows Taskbar bar. Do you see icon which has a page and yellow question mark next to Quest SQL Optimi…? This is the Help window. If it is there, you should be able to click it to see the window.
You do not need Knowledge Expert for this feature.
Let me know if you can find the window or if it is still missing.
please do let me know what happens with your tests, if there is a work around or not. Also i think SQL optimizer dont work for 64 bit OS computer. As at my company, we had to get new OS on some laptops just to use the tool(fyi)
Based on your information provided, we have tested this function again and confirmed that it is not working in Vista.
I am sorry to tell you that there is currently no workaround available. However, if you would like to access the plan help information, you may actually find them in the On-line Help. You may click F1 to open it or through the program shortcut under Start. All plan information are stored under Quest SQL Optimizer for Oracle | SQL Operations in the Contents tree.
As for 64-bits environment, you are right that current version is not supported. We are looking into supporting it in our next release.
Thank you and let me know if you have further questions.
