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 the importance of a database?
Explain the Logical Schema of Database
Have you heard about sixth normal form?
Mention a query to add email validation to your database
If you need to refresh a website page every time a record is updated in database, how would you do it?
Why is group-clause used?
Which software is best for database?
What do you mean by buffer manager?
What is data independence and also explain its types?
Define sub-query.
What is database definition (dbd)?
How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?
Do we consider null values the same as that of blank space or zero?
Why dbms is used?
Define database.