WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
Answer Posted / deepak soni
if you talk about sql you should create clusterd index
but in oracle you have to create indexes to improve the
performance of query or you can say retrive the data in
faster rate.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is normalization and what are the different types of normalization?
What is a database report?
Where is the data stored in a database?
What is a field in database?
What is dbms_output put_line?
Explain what is a deadlock and mention how it can be resolved?
Why do I need netlib?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
What do you mean by cardinality and its types?
What is meant by database management system?
What is dbms introduction?
Define transaction and transaction isolation levels?
Mention the differences between union and union all
What is rdbms and its types?
How can I join two tables in database?