index
From: <aarklon_at_gmail.com>
Date: Mon, 28 Jul 2008 07:15:05 -0700 (PDT)
Message-ID: <778b7db5-39ef-4fcd-afc7-0083fd46e625@z26g2000pre.googlegroups.com>
Date: Mon, 28 Jul 2008 07:15:05 -0700 (PDT)
Message-ID: <778b7db5-39ef-4fcd-afc7-0083fd46e625@z26g2000pre.googlegroups.com>
Hi all,
I read the following in a book
- we can have several non clustered indexes on a table , but we can have only one clustered index per table
- index on the primary key can be clustered or non clustered
now my question is
- by default what sort of indexing is used in oracle ?