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 are 4 types of models?
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
How many types of relationship exist in database designing?
What is a relation in dbms?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What are the different technologies used to access Database from Visual Basic?
What is a string in database?
How do you handle your own transaction?
What are the advantages and disadvantages of views in the database?
What does fill factor concept mean with respect to indexes?
What is sql and where is it used?
What are the functions of database management system?
What are the advantages of manual database?
How do you create a report in a database?
Explain the terms specialization and generalization.