Database Administration (MOSC)

MOSC Banner

How does Oracle decides and returns the rows for a Select statement

edited Sep 8, 2020 5:29AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hi,

I have a very basic question on select query results.

When I run SELECT * FROM TABLE_NAME (no additional clause), how does Oracle decides which rows to present first and what mechanism does Oracle follows internally.

I checked the indexes and verified internal row_ids but I am unable to find a proper understanding.

I understand how it parses the SQL and the priorities of ORDER BY, GROUP BY etc. My question is related to the exact query "SELECT * FROM TABLE_NAME".

Please help me understand.

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