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...


What is index? How many types of indexes?

Answers were Sorted based on User's Feedback



What is index? How many types of indexes?..

Answer / kishore

Index is a performance tuning method of allowing faster
retrieval of records. Oracle indexing is a standing B-Tree
indexing for fast retrieval.

Syntax: CREATE INDEX EmpInfo ON Employee(EmpID,Emp_Name)

we have two types indexes

1. Clustered indexes
2. Non-Clustred indexes

Is This Answer Correct ?    36 Yes 9 No

What is index? How many types of indexes?..

Answer / ruchi

index is a data structure used for fast retrival of data.

Is This Answer Correct ?    7 Yes 3 No

Post New Answer

More Oracle AllOther Interview Questions

deference between & and &&

2 Answers   Mphasis,


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

0 Answers  


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  


What is the difference between oracle media recovery and crash recovery?

0 Answers  


types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  


statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,


how to write customizations in po

0 Answers   Ernst Young,


What is chargeback invoice? How do we create it? : oracle accounts receivable

0 Answers  


how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 Answers  


what are basic modules required to implement oracle application in any oraganisation?

0 Answers  


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

0 Answers  


I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)