INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND ALSO IT IS US

Give the reasoning behind using an index.

Question Posted / rajesh naidu

Answer Posted / rajesh naidu

INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1015

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1976

How to start SQL Server in minimal configuration mode?

7975

what are the differences of where and if in SAS?

2196

what do you understand by flashback feature of oracle?

995

how can a session indicate its interest in receiving alerts?

1045

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

1008

how to restore files with rman?

2304

What is dbcc? : sql server DBA

1292

Explain about your sql server dba experience? : sql server DBA

1088

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2622

what are the benefits of flashback feature?

1024

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1975

What is a correlated sub-query? : sql server DBA

1087

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2440