SQL Performance (MOSC)

MOSC Banner

Question on Performance

edited May 21, 2014 12:00PM in SQL Performance (MOSC) 2 commentsAnswered

I've never been on the forum before .   We have a very complex query we are trying to optimize.  We did not write it, but have to fix it.   A select statement can be put into the Select Clause, the From Clause, and the Where Clause.  Is there a performance advantage to one location as opposed to other locations.  Somewhere in the back of my mind, I thought if you create select statements in the From Clause it runs once (like a temp table) and then uses the info for all the records being queried.   I appreciate your expertise on this.

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