SQL Performance (MOSC)

MOSC Banner

What does the INLINE hint do?

I have developers adding this to a lot of queries. But I cannot find an actual definition. It is not in the documented hints though it is listed as a workaround to numerous bugs..

The developers use this in combination WITH clauses

WITH view1 as (SELECT /*+ INLINE */ ... )

select /*+ INLINE */ from a where ...

I just need a description of what it actually does so I can explain to developers when it is appropriate and when it is not. I suspect they found a hammer and just throw it in whenever something is slow. Tables have billions of rows.

Thanks

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center