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

Question Posted / franklin.2710

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

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

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

2 Answers

how can you process messages in order asynchronously?

0 Answers Oracle,

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers

Can we take incremental backups in datapump?

1 Answers

What is fill factor? : sql server DBA

0 Answers

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

what r the types of backup?

5 Answers CSC,

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers

For more DB Administration Interview Questions Click Here