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

Question Posted / franklin.2710

3 Answers
7782 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 can we see the database version in os level

6 Answers Oracle,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers

what do you understand by fine-grained auditing?

0 Answers Oracle,

one datafile is lost in standy side how can you recover that??

2 Answers

Explain the use of table functions.

1 Answers

What happens on checkpoint? : sql server DBA

0 Answers

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

who owns the operating system files created by the utl_file package?

0 Answers Oracle,

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers TCS,

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers

how can you get actual data change values from previous transactions in oracle?

0 Answers Oracle,

when does an alert gets signaled?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here