Index-- 4 question [message #123087] |
Thu, 09 June 2005 16:46 |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
Hi,
My question is as below...
[1] What is index?
[2] What is B-tree indexing?
[3] what is Bitmap Indexing?
[4] what are differenc between B-tree and B-bitmap indexing?
Note:- Please answer in short and to the point.
From :- Sunilkumar
|
|
|
Re: Index-- 4 question [message #123098 is a reply to message #123087] |
Thu, 09 June 2005 18:11 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
An index in the database is similar to one in a book, or even in (just for example) the online documentation. Instead of searching the entire book from beginning to end (equivalent to a full table scan), if you have a particular item to look up you can quickly search the index and it tells you where to find what you're looking for. In Oracle an index gives you the physical block address where the row is stored.
Quote: | Note:- Please answer in short and to the point.
|
LOL! You're a funny guy.
|
|
|
|
|
|
Re: Index-- 4 question [message #123160 is a reply to message #123124] |
Fri, 10 June 2005 04:16 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
Sunil
Theres no substitute to reading a documentation on these topics..
& remember 90% of all the replies that u get here are either excerpts from or actual links of docs... pls do take some pain in going thru these links... these will answer u in best fashion.
....Girish
|
|
|
Re: Index-- 4 question [message #123257 is a reply to message #123160] |
Fri, 10 June 2005 17:00 |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
respected member of forum,
I think i should only search the links of documents pertaining to any issue ... and even if i know some answer of other question than i should give them link of the documentation ... not the solution .... and if someone feel that giving answer to my question is .. time consuming, wasting of time and my question is funny then dont reply to it.... any way for solution i have to search link and documentation....
Why people post question on the forum?... to get answer... which should be to the point.
Yea i know there is no better answer to the problem other than oracle documentation... but still people come on forum y?
Thank you to all those who had replied to my question uptill now.
Wish you a great life
By:- Sunil
|
|
|
|
|
Re: Index-- 4 question [message #123266 is a reply to message #123087] |
Sat, 11 June 2005 00:23 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Don't you think it's a bit strange you're asked about database tuning when you don't even know what an index is?
(...and you don't know how and when to read the docs)
hth
|
|
|
|