I have query like this.
select dept_id, max_mark from stude_dept where min_mark=
(select min(mini_mark) from stud_dept);
How can i optimize this query.
Can anyone help me with it
- 2 Answers
- 3921 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhakar
hi
it gives mini_mark record of max_mark,dept_id
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the order of defining local variables and sub procedures/functions?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to pass a cursor variable to a procedure?
What is a cognitive schema?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is a snapshot in oracle database?
What suggestions do you have to reduce the network traffic?
How to create an initialization parameter file?
How many file formats are supported to export data?
How to write a query with a right outer join in oracle?
What is raw datatype in oracle?
does the query needs a hint to access a materialized view?
What is an oracle user account?
What is redo log?
Explain the characteristics of oracle dba?
