Re: index
From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Mon, 28 Jul 2008 14:27:59 GMT
Message-ID: <PHkjk.262$JH5.87@trnddc06>
Date: Mon, 28 Jul 2008 14:27:59 GMT
Message-ID: <PHkjk.262$JH5.87@trnddc06>
<aarklon_at_gmail.com> wrote in message
news:778b7db5-39ef-4fcd-afc7-0083fd46e625_at_z26g2000pre.googlegroups.com...
> 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 ?
This is not sql server. We have unique indexes, non-unique indexes, bit
mapped indexes, function based indexes. You specify which one you want.
There really isn't a default.
Jim
Received on Mon Jul 28 2008 - 09:27:59 CDT