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

How do convert or display the date or time as string?

715


What is difference between database and spreadsheet?

552


What is difference between database and website?

577


Define normalization.

645


Which is the best database?

578






Define transaction and transaction isolation levels?

624


Explain the different types of join operations?

583


What are the key constraints in dbms?

601


What is an artificial (derived) primary key? When should it be used?

550


Define entity set.

587


What are the types of database management system?

607


Can we store images in database?

549


Explain degree of a relation?

561


Explain the Logical Schema of Database

651


What do you understand by sub-queries in sql?

554