Query processing is slow(eg select query)how will u solve that
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
What would you do with an "in-doubt" distributed transaction?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Explain materialized views and how they are used.
How to start SQL Server in minimal configuration mode?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is dbcc? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
who owns the operating system files created by the utl_file package?
What are the different sql server versions you have worked on? : sql server DBA
how can you connect from 10g user to 11g user??
How do you open a cluster administrator? : sql server DBA