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
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the different sql server versions you have worked on? : sql server DBA
which background process invoke at the time of upgradation tell me???
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you schedule a job in database?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different types of indexes available in sql server? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
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
What is a correlated sub-query? : sql server DBA
How do you open a cluster administrator? : sql server DBA