WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
Answers were Sorted based on User's Feedback
Answer / priya sahoo
create index on the table so that query retrival is faster
Is This Answer Correct ? | 18 Yes | 2 No |
Answer / 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 |
Answer / muzaffar ali umrani
first check is there any index created in on that table, if yes then arrange your query according to index and check its execution plan and if there is no index on query then create the index.
Is This Answer Correct ? | 7 Yes | 0 No |
What is the easiest database to learn?
What does <> mean in database?
Discuss transparent DBMS?
What do you understand by index hunting?
What is the definition of database management system?
Why do we need database management?
What do you understand by the view and mention the steps to create, update and drop a view?
What is metadata and why should I use it?
Does google have a database program?
What is the advantage of database management system?
What do you understand by ‘database’?
what is the location of oracle inventory?