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
Why do we need database?
Why is data modelling important?
What is inner join in database?
What's the difference between star and snow flake schema?
Mention the differences between the clustered and non-clustered index
How do I keep my database up to date?
What are the database skills?
How to drop all foreign keys in database?
What is atomicity in dbms?
How can we check whether A S M instance is up or down?
Enlist the various transaction phases.
What is the database approach?
What are the advantages of database software?
How many types of relationship exist in database designing?
What do you mean by durability in dbms?