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


Please Help Members By Posting Answers For Below Questions

What is 3nf in dbms?

491


What is Schema in DBMS?

576


What is the difference between a shared lock and exclusive lock?

491


Explain primary key and composite key.

535


What is the structure of a database?

466






What is the purpose of a field in a database?

452


What are new features postgre 9.1?

497


what are the differences between an exclusive lock and a shared lock?

491


What is computer end?

505


What is ordbms with example?

511


What is super key in dbms?

497


Write about Transaction Management in Oracle 9i?

1665


Explain concurrency transparency.

582


What are the types of tables in database?

481


What is a checkpoint and When does it occur in database?

681