OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Index-- 4 question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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.

Report message to a moderator

Re: Index-- 4 question [message #123100 is a reply to message #123087]

Thu, 09 June 2005 18:35

DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand

Member

Short and to the point - try reading the documentation

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/schema.htm#sthref956

Dougie McGibbon

Report message to a moderator

Re: Index-- 4 question [message #123116 is a reply to message #123100]

Thu, 09 June 2005 21:34

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hello....

thanks for sending me the link but it is like seeing some book on index .... even i can get from the documentation .... and to be very honest only few people give answer to the point without sending any link.. i am expecting reply from them....... william i am really funny ... and you should know my nick name is sunny ... ha ha...
by the way i never mean to hurt u .... so dont take it on your heart....
I m really thankful for your and DMcG reply to my question ....

Note:- [1]Link is usefull
[2]I am expecting reply from Mahesh or frank or girish or smartin Smile

By:- Friend
Sunilkumar

Report message to a moderator

Re: Index-- 4 question [message #123124 is a reply to message #123116]

Thu, 09 June 2005 23:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> and to be very honest only few people give answer to the point without sending any link.. i am expecting reply from them.......

And honestly, i beleive, you really didn't mean to be as sarcastic as your posting implies. Obnoxious postings will not help anything.

>>What is index
>>what is oracle
>>why should i read documentation

And any similiar questions are supposed to get an RTFM response.
William Robertson was kind enough and gave a beautiful example for what index really means. Unfortunately you never got it (Or you may have. But your posting is not reflecting it).

Could anyone justify why is it so hurting when asked to read the documentation?

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Re: Index-- 4 question [message #123259 is a reply to message #123257]

Fri, 10 June 2005 17:18

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I think i should only search the links of documents pertaining to any issue

question: [1] What is index?

Is this an issue?

>>Why people post question on the forum?... to get answer... which should be to the point

Your question, was answered to-the-point and is-technically-explained-in-documentation.
For that reason, you are asked to read it.

>>and even if i know some answer of other question than i should give them link of the documentation ... not the solution

I dont understand what you are talking about.

Report message to a moderator

Re: Index-- 4 question [message #123263 is a reply to message #123259]

Fri, 10 June 2005 20:04

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Please,

What is an index ?.... big issue for me from personal point of view.. question asked to me in an interview...

Any one have speicific answer to such question present in below link. by the way what is there in answer i had mentioned to the interviewer but they were not satisfied.... can any one tell me what answer interviewer is looking for.......

http://www.orafaq.com/forum/?t=rview&goto=113095#msg_113095

http://www.orafaq.com/forum/?t=rview&goto=117189#msg_117189

http://www.orafaq.com/forum/?t=rview&goto=117934#msg_117934

http://www.orafaq.com/forum/?t=rview&goto=117851#msg_117851

check all the link .... all question are asked to me in an interview of big company..........

Report message to a moderator

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

Report message to a moderator

Re: Index-- 4 question [message #123357 is a reply to message #123266]

Sun, 12 June 2005 14:34

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Frank have u goen through the 4 link . . . . Very Happy

http://www.orafaq.com/forum/?t=rview&goto=113095#msg_113095

http://www.orafaq.com/forum/?t=rview&goto=117189#msg_117189

http://www.orafaq.com/forum/?t=rview&goto=117934#msg_117934

http://www.orafaq.com/forum/?t=rview&goto=117851#msg_117851

such question where asked to me in an interview. . . . if you have specific answer to that question then please let me know i will be thankful to you.

By the way what i understand by B-tree and Bit-map index is as below well i m not expert like you so if my answer are wrong then please let me know what wil be the correct answer. .

B-Tree index: - It is a default index if we don’t specify any thing oracle will create b-tree index. It is used for cardinality (i.e. low occurrence of value in a column) cardinality means occurance of a value in a column.

Bit-Map: - High occurrence one value repeating many times

Function Base: - It Means we combing some function, it is requirement based index internally it works as B-Tree index i.e. searching only Mrs. I mean to say using function to find Mrs.

Thank you
By:-Sunil

Report message to a moderator

Previous Topic:	How to use imp corretly when I have a lot of tables in oracle already.
Next Topic:	Database creation script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:23:27 CDT 2024