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

Question Posted / franklin.2710

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

what is the difference between db2start command and start database manager command?

1 Answers

which background process invoke at the time of upgradation tell me???

0 Answers iGate,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

how will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

Which autogrowth database setting is good? : sql server DBA

0 Answers

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

0 Answers Oracle,

what is a crs resource?

0 Answers Oracle,

What view would you use to look at the size of a data file?

3 Answers

why Datapump is faster than traditional export and import

4 Answers Mphasis,

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here