Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is APEX optimization behaves differently than SQL Developer?

Kinjan BhavsarNov 21 2020 — edited Nov 24 2020

Hi All,
I have come across one issue for one of my SQL queries.
When I run that page using LEVEL9 debugging, it gives me explain plan and in that one of table is showing as FULL SCAN and when I run same query with same parameters in SQL Developer, it uses the index and gives results in milliseconds.
Has someone faced similar issue or is there any way/steps to follow so the query uses proper index in APEX?
I am using APEX 18.2 and I have attached examples of explain plan from both APEX and SQL Dev.
From the screenshot you can see that in APEX it is showing cost as 3190 and in SQL Developer it is showing 24. I further found by checking each step of explain plan that one of my database table is doing a full scan in APEX and using proper index in SQL Developer so I am getting confused why would such thing happen.
I tried rebuilding all indexes of that table but it has same issue in APEX.
Can someone suggest what can I do to resolve this issue.

Comments

SteveB
Answer

Check out Preferences, Shortcut Keys. For Mac, it looks like this:

Screen Shot 2017-04-20 at 12.53.47 pm.png

Hope this helps,

Steve

Marked as Answer by thrupass · Sep 27 2020
1 person found this helpful
Gaz in Oz

It appears that <ALT>[ and <ALT>] are defined by default. (pressing <ALT> "either square bracket" will toggle between opening and closing bracket pair).

You have to have the cursor right next to a bracket for it to match its paired bracket.

pastedImage_0.png.

Redefining one or other to <ALT>5 will kind of mimic vi, except it is <ALT>5 instead of vi's <SHIFT>5 (%).

Note: <ALT>5 may already be defined and this will override that.

1 person found this helpful
thrupass

Thanks

1 - 3

Post Details

Added on Nov 21 2020
#apex, #apex-discussions, #database, #performance, #sql-developer
4 comments
301 views