Interested to Buy Any Domain ? << Click Here >> for more details...
Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7924 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
1) Find the cost.
2) Check what tables are going full table scan.
3) Create Indexes if is possible.
4) Re-write the query to optimize the cost with modifying
filter condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is dbcc? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you process messages in order asynchronously?
How can you control the amount of free space in your index pages? : sql server DBA
what are the differences of where and if in SAS?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
when does an alert gets signaled?
What are the recovery models for a database? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
