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 |
How does a database store data?
What is data in dbms?
What are the steps in creating a database?
What are the different type of relationships in the dbms?
How is view stored in database?
What is a Federated Query ?
Explain the main control blocks available in ims db?
Where the Databases overall structure is maintained ?
What built in subprogram is used to manipulate images in image items ?
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
Can we store images in database?
Explain primary key and composite key.