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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2063


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17625


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1287


difference of using cursor for loop and open,fetch,close.which one is better

1799


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1332


3. Steps in UAT?

2429


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1164


which one is currently in used software cmpanies.

2143


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7957


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2392


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2065


What is auto invoicing? : oracle accounts receivable

1150


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2944


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2182


What are different types of transactions in ar? : oracle accounts receivable

1282