Home » SQL & PL/SQL » SQL & PL/SQL » indexes storing.
indexes storing. [message #191416] Wed, 06 September 2006 04:58 Go to next message
charankarthikeyan
Messages: 16
Registered: August 2006
Junior Member
hi,

how column values & row id stored in
oracle b-tree index & bitmap index.



thanks karthik
Re: indexes storing. [message #191431 is a reply to message #191416] Wed, 06 September 2006 06:19 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Question is not clear. Please clarify. And I do mean clarify, don't just repeat the question with a couple of extra words. Sow us that you have a basic understanding of what an index is - because, of course, you have read the documentation on this topic, and have search the web and this forum for possible related topics and you just need further clarification
Re: indexes storing. [message #191441 is a reply to message #191431] Wed, 06 September 2006 06:48 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
... and it would also be nice to know why You are interested in how Oracle stores this information.

Maybe, if we knew why You ask this, we could answer You easily.

Br
Kim
Re: indexes storing. [message #191463 is a reply to message #191416] Wed, 06 September 2006 07:49 Go to previous messageGo to next message
charankarthikeyan
Messages: 16
Registered: August 2006
Junior Member
hi,
when i index a column
oracle fetches the indexed columns, sorts it & stores it with the rowid for faster access on the table

for ex:
emp empname row
103 c 1
102 b 2
101 a 3

if i index on empname then
empname row
a 3
b 2
c 1

well i just want to know b-tree & bitmap index works..
Re: indexes storing. [message #191474 is a reply to message #191463] Wed, 06 September 2006 08:28 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
For a question such as
"How does a Bitmap index work" you really have to read the documentation.
Have a look at the concepts guide
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96524/c11schem.htm#5381

If you have more specific questions, please post back.

Jim
Re: indexes storing. [message #191532 is a reply to message #191416] Thu, 07 September 2006 00:49 Go to previous messageGo to next message
charankarthikeyan
Messages: 16
Registered: August 2006
Junior Member
hi,

thank u jim for your kind assistance, from where i can get this entire document about oracle, or can u help me out.

karthik
Re: indexes storing. [message #191549 is a reply to message #191532] Thu, 07 September 2006 01:55 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Go to http://otn.oracle.com and select "documentation".

Br
Kim
Re: indexes storing. [message #191565 is a reply to message #191532] Thu, 07 September 2006 02:35 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Or alternatively, you could have clicked on 'Home' which would have taken you to the source of ALL the documentation!
Re: indexes storing. [message #191595 is a reply to message #191565] Thu, 07 September 2006 03:55 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
JSI2001 wrote on Thu, 07 September 2006 09:35

Or alternatively, you could have clicked on 'Home' which would have taken you to the source of ALL the documentation!

But that would require me to scroll all the way up. Nobody told me it would be that much work !
Re: indexes storing. [message #191612 is a reply to message #191595] Thu, 07 September 2006 05:28 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Laughing
Previous Topic: How to handle BLOB data
Next Topic: Import Data, Sequence still at 1
Goto Forum:
  


Current Time: Fri Dec 02 20:37:20 CST 2016

Total time taken to generate the page: 0.13708 seconds