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

Question Posted / franklin.2710

3 Answers
7157 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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers HSBC,

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers

the process of adding a cpu in sql server is called..?

2 Answers TCS,

Explain the concept of the DUAL table.

3 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

What would you do with an "in-doubt" distributed transaction?

0 Answers

Can we take incremental backups in datapump?