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

Question Posted / franklin.2710

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

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

what functionality does oracle provide to secure sensitive information?

0 Answers Oracle,

How to determine the service pack currently installed on SQL Server?

1 Answers

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

how will you see when the database was started using sql prompt?

2 Answers IBM,

What is RAID and what are different types of RAID configurations?

1 Answers

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

Why would you call update statistics? : sql server DBA

0 Answers

Explain CREATE DATABASE syntax?

2 Answers

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

0 Answers

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers

For more DB Administration Interview Questions Click Here