When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / umashankar
1.The PARSER scans/reads the SELECT statement and splits it
into some logical units such.
i.e: keywords/reserved word, operators, expressions and
identifiers.
2. SEQUENCE TREE or QUERY TREE is built the logical steps
needed to transform the source data into the format as
needed by the end result.
3. The QUERY OPRIMIZER analyzes the query in various ways
and selects the series of steps that returns the end
results fastest way. The query tree is updated to record
this exact series of steps. The final, optimized version of
the query tree is called the execution plan.
4. The RELATIONAL ENGINE starts executing the execution
plan which was prepared by the Query Optimizer.
5.The RELATIONAL ENGINE requests the STORAGE ENGINE pass up
data from the rowsets requested.
6. The RELATIONAL ENGINE processes the data (returns all
column values from EMP table) returned from the storage
engine to the client.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is a database? : Sql dba
What does data normalization mean?
Explain raise_application_error.
What are sql data types?
Why do we use sqlite?
how to use myisamchk to check or repair myisam tables? : Sql dba
Can a foreign key be null?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is the difference among union, minus and intersect?
What is the difference between clustered and non-clustered indexes?
Explain clause in sql?
What does inner join mean?
what is the difference between $message and $$message? : Sql dba
What are inner outer left and right joins in sql?
Can we create table inside stored procedure?