1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / franklin.2710

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 you enable a trace for a session?

1 Answers  

when does an alert gets signaled?

0 Answers   Oracle,

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  




Describe what redo logs are.

1 Answers  

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

1 Answers  

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

0 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

what do you understand by fine-grained auditing?

0 Answers   Oracle,

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

0 Answers   Oracle,

how can you implement fine-grained auditing?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories