When tuning a query which looks relatively simple, you might see a long complex execution plan. What's going on there? It's likely your developers are hiding complex business logic with Oracle views so that they can write simple queries against those views. DBA_VIEWS is the place you usually go and find the definition of a … Continue reading Will DBMS_UTILITY.EXPAND_SQL_TEXT make your life easier? →