OraFAQ Forum: SQL & PL/SQL » storage structures in Oracle 9i

Home » SQL & PL/SQL » SQL & PL/SQL » storage structures in Oracle 9i

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

storage structures in Oracle 9i [message #9576]

Thu, 20 November 2003 23:57

Víctor
Messages: 17
Registered: October 2001

Junior Member

How do I implement storage structures in Oracle 9i like B+ tree and hashing, and also structures that facilite insertion and deletion. Thanks in advance

Report message to a moderator

Re: storage structures in Oracle 9i [message #9583 is a reply to message #9576]

Fri, 21 November 2003 09:55

Thiru
Messages: 1089
Registered: May 2002

Senior Member

you mean you want to create tables and Btree Indexes ?

Tables = storage structures that support Selects,Inserts,Updates,Deletes etc
Indexes = storage structures that speed up queries and sorts

Start with Oracle concepts guide at tahiti.oracle.com

-Thiru

Report message to a moderator

Re: storage structures in Oracle 9i [message #9587 is a reply to message #9583]

Fri, 21 November 2003 11:19

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Also, Index Organized Tables (IOT) combine the two things in one shot, as they are basically indexes with data stored in the same blocks.

Report message to a moderator

Re: storage structures in Oracle 9i [message #9590 is a reply to message #9587]

Fri, 21 November 2003 11:41

Thiru
Messages: 1089
Registered: May 2002

Senior Member

It looks like he is just getting started and so I dont think its appropriate to introduce IOTs at this time. They are meant to be used in special situations.

Also , when posting , pls 'reply' to the requestor directly .

Thanks
-Thiru

Report message to a moderator

Previous Topic:	which kind of index should I use?
Next Topic:	SQL Query - How can this be done

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 01:58:14 CDT 2024