what are indexes..how many types of index's are there and
what are they?

Answer Posted / guest

when queries are run against a DB,an index on that DB
basically helps in the way the data is sorted to process
the query for faster data retievals.

There are basically two types of indexes that we use in SQL
Server. Clustered and the Non-Clustered.

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to assign a tablespace to a users in oracle?

591


How to check your oracle database 10g xe installation?

581


What happens if you use a wrong connect identifier?

504


Explain oracle 12c new features for developers?

540


What is the difference between sharding and replication?

479






What is an Oracle index?

1179


Is there any function in oracle similar like group_concat of mysql?

541


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1211


Can you have more than one content canvas view attached with a window ?

1817


How to define an anonymous block?

618


How to write text literals in oracle?

614


Where is the export dump file located?

575


How to insert a new row into a table in oracle?

591


1) Does oracle have any table which contain all the exceptions and it's code internally?

1282


What is archive log in Oracle?

601