If a user complaint his query run slow how u detre mine which is reason ? -

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

DETAILS

Question: If a user complaint his query run slow how u detre mine which is reason ?

Answer:

Category	Database Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 7357 users
Added on	5/20/2013
Views	72221
Rate it!

Question: If a user complaint his query run slow how u detre mine which is reason ?

Answer:

Source: CoolInterview.com

the reason can be large database .
other reason can be multiple inner queries . Or wrong input. Source: CoolInterview.com

Answered by: kunal | Date: 4/26/2010 |

Contact kunal

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Which files of unix or linux use or configure in oracle installation ?	View Answer
	If i create unquie index on empid of employees table which index i create bitmap or btree why ?	View Answer
	How data store in bitmap & btree index what is benefit ?	View Answer
	what type of indexes?	View Answer
	How sga use if i execute select * from emp where empid=111;	View Answer
	Is it possible we can define the path of control file backup by creating a text tarce file default where this is store ?	View Answer
	Why are we not use tablespce begin backup with read only tablespace?	View Answer
	Is it same we set log_archive _start =true or alter system archive log start if u use any one then automatic archive ing start or not ?	View Answer
	User say your database is slow how you solve this how identified reasons ?	View Answer
	what is listner how u can change default name & port	View Answer
	What is standard parameter at database creation?	View Answer
	What is the difference between 9i and 10g?	View Answer
	What is dblink and how use it ?	View Answer
	I have different sources in different databases these sources may be have 100 tables. I want to load these tables into a single target. How can we perform this task ?	View Answer
	Write the T-SQL code to get the last day of the month ?	View Answer
	What is the difference between sql and pl/sql?	View Answer
	When is a database is not a database?	View Answer
	How to modify already created table?	View Answer
	What is the meaning for data base without using technical terms?	View Answer
	What is Normalization? explain all the normal forms.	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Database Interview Questions & Answers - Exam Mode / Learning Mode