Your query return 80 % data from table is it we use index or not why ? -

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: Your query return 80 % data from table is it we use index or not why ?

Answer:

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

Question: Your query return 80 % data from table is it we use index or not why ?

Answer:

Source: CoolInterview.com

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
	How you can determine query use full table scan?	View Answer
	I don't set user dump test parameter where trace file default store on linux platform.	View Answer
	where is trace file generate & when this is create .	View Answer
	How you implement trace of query when user run query what is syntax ?	View Answer
	If a user complaint his query run slow how u detre mine which is reason ?	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

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