Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7192 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
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what do you understand by flashback feature of oracle?
What is fill factor? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
who owns the operating system files created by the utl_file package?
internal architecture
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What is a correlated sub-query? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
