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

Why are databases so important?

685


Is this statement true or false? All databases must be in third normal form?

717


What is database definition (dbd)?

698


What is network database?

769


What do you understand by data independence? What are its two types?

805


How view is related to data independence?

699


What is the role of tables in database?

665


Can you explain the 'between' clause?

820


What happens when my integer identity runs out of scope?

632


What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

627


what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?

1571


What do you mean by cardinality and its types?

688


What do you understand by the view and mention the steps to create, update and drop a view?

638


What is environment of openedge?

690


What is 3nf in the dbms?

677