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 are service-specific middleware?

518


What is considered a database?

480


How many types of users in dbms?

449


dear sir please provide what question will be asked in bank it officer interview

1724


How do queries work in a database?

505






What is db flush?

488


How to change database dialect?

524


How does notification services work?

518


Explain what are service-specific middleware?

542


Differentiate between nested loop, hash loop and merge join.

483


Operators used in select statements are?

491


Is there an example how to configure udfaccess setting in firebird.conf?

494


How to handle data if f table are more than one and each table contain thousands of entries?

1663


Explain the importance of partitioning.

571


What are the main components of a database system?

447