SQL Performance (MOSC)

MOSC Banner

sql profile vs Custom SQL profile

edited Jan 28, 2014 11:16AM in SQL Performance (MOSC) 2 commentsAnswered

 Hi,


I was reading the following Metalink Note:  Using Sqltxplain to create a 'SQL Profile' to consistently reproduce a good plan (Doc ID 1487302.1) and wondering about types of SQL profile.

Could someone shed light on these types of SQL profile.  

types of 'SQL Profile

"There are 2 types of profiles, although currently there are no names to distinguish them
  • One that "fixes" the plan and produces exactly the same plan (this would be equivalent to the old 'stored outlines'). This is the type of profile that we will be using in this note.
  • One that does not "fix" the plan, but  provide some hints such as "scalling factors" that allow the optimizer to produce a new plan if conditions change, like more data. This is typically what the SQL Tuning Advisor provides" 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center