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

Question Posted / franklin.2710

3 Answers
6485 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

What is checkpoint?

3 Answers Accenture,

What happens on checkpoint? : sql server DBA

0 Answers

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

0 Answers iGate,

What does coalescing a tablespace do?

1 Answers

how to restore files with rman?

0 Answers

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

How would you go about increasing the buffer cache hit ratio?

2 Answers

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

What is fill factor? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here