Re: index
Date: Mon, 28 Jul 2008 12:35:25 -0700
Message-ID: <1217273718.981972@bubbleator.drizzle.com>
aarklon_at_gmail.com wrote:
> Hi all,
>
> I read the following in a book
>
>
> 1) we can have several non clustered indexes on a table , but we can
> have only one clustered index per table
>
>
> 2) index on the primary key can be clustered or non clustered
>
>
> now my question is
>
>
> 1) by default what sort of indexing is used in oracle ?
Oracle is not a Microsoft product. A SQL Server clustered index is essentially the same construct as an Index Organized table.
Please go to http://tahiti.oracle.com and start with the basic concept and architecture books. If you are working with Oracle you need to have at least a passing familiarity with it.
As it is your statements make no sense so no other response is possible.
PS: What book?
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Jul 28 2008 - 14:35:25 CDT