Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How many different types of indexes we have in oracle?

Answer Posted / ananthram

Just and Addition to the above discussion.
I cant agree completely with answer #3 when it says
"This index is not Unique index "
Because Oracle makes sure that the uniqueness is maintained
in case of Primary and unique key by imposing UNIQUE INDEX
on it.
So I find it difficult when someone says that the implicit
indexes created by oracle while the creation of PK and UK
are not UNIQUE indexes.

Is This Answer Correct ?    32 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between PFILE and SPFILE in Oracle?

1112


How different is ms access and oracle?

1092


Why we use bulk collect in oracle?

1118


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1161


State and explain about oracle instance?

1053


What is hash cluster in oracle?

1250


How to define an oracle sub procedure?

1232


How to compare dates in oracle sql?

1162


Explain a segment?

1131


How much memory your 10g xe server is using?

1153


What is oracle instant client?

1070


Describe varray?

1118


What is ceil and floor in oracle?

1123


What are the attributes of the cursor?

1060


How to export your connection information to a file?

1177