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

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 is rebuild index??

2 Answers   IBM, Sapient,

What the different components in replication and what is their use? : sql server DBA

1 Answers  

What purpose does the model database server? : sql server DBA

1 Answers  

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 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

1 Answers  

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1 Answers  

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1 Answers  

How do you open a cluster administrator? : sql server DBA

1 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1 Answers  

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

1 Answers  

For more DB Administration Interview Questions Click Here
Categories