WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
Answer Posted / 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 |
Post New Answer View All Answers
What is 3nf in dbms?
What is Schema in DBMS?
What is the difference between a shared lock and exclusive lock?
Explain primary key and composite key.
What is the structure of a database?
What is the purpose of a field in a database?
What are new features postgre 9.1?
what are the differences between an exclusive lock and a shared lock?
What is computer end?
What is ordbms with example?
What is super key in dbms?
Write about Transaction Management in Oracle 9i?
Explain concurrency transparency.
What are the types of tables in database?
What is a checkpoint and When does it occur in database?