WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
- 4 Answers
- 7139 Views
- CTS, iNautix, TCS, I also Faced
- E-Mail Answers
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
Explain a join between tables?
What are collection pools? What are the advantages?
What is instance in dbms?
List few disadvantages of file processing system.
Define transaction and transaction isolation levels?
Explain the hierarchical database?
What is a sequence in a database?
Which is the best database?
What is a database report?
State some commands of ddl in dbms?
How to move a multi-file database?
What is user and end user?
What is the difference between multiload and fastload interms of performance?
explain the term ‘attribute’?
What is the main purpose of triggers in database?
