Query processing is slow(eg select query)how will u solve that

Question Posted / franklin.2710

3 Answers
7753 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Query processing is slow(eg select query)how will u solve that..

Answer / kumarayyalusamy

We will tune that query

Is This Answer Correct ?

7 Yes

2 No

Query processing is slow(eg select query)how will u solve that..

Answer / jayesh

WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE

Is This Answer Correct ?

5 Yes

2 No

Query processing is slow(eg select query)how will u solve that..

Answer / 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

More DB Administration Interview Questions

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

What is the default fill factor value? : sql server DBA

0 Answers

what is meant by gateway

1 Answers IBM,

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

What is blocking and how would you troubleshoot it?

1 Answers

which background process invoke at the time of upgradation tell me???

0 Answers iGate,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers

For more DB Administration Interview Questions Click Here