Re: indexes

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Fri, 04 Aug 2006 22:14:05 GMT
Message-Id: <pan.2006.08.04.22.16.21.617810@gmail.com>

On Fri, 04 Aug 2006 21:38:25 +0000, Brian Peasland wrote:

> laredotornado_at_zipmail.com wrote:

>> Hi,
>>
>> I got this question on an interview, but was unsure of the answer.
>> Could you help?
>>
>> What are the two types of indexes and how are they stored differently?
>>

> 
> Only 2? My answer would have been that there are more than 2. And then I 
> would have gone from there....
> 

Of course there are only 2 - useful and useless indexes.

Useful ones are stored on disk in useful ways ....

The link I referenced actually indicates 5 or 6 different 'types'. However, I believe the 'questioner' had read somewhere that Oracle introduced 'Bitmap indexes' as comared to thge original 'B*Tree indexes'.

I wonder whether the 'questioner' knows the difference betweem 'B-Tree', 'B*Tree' and 'B Tree' storage? <g>

If I was doing the questioning, the answer I would have *wanted* would have been: "It's in the Concepts manual, probably in the Chapter on Indexes. Let's look it up."

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Aug 04 2006 - 17:14:05 CDT