index
From: <aarklon_at_gmail.com>
Date: Mon, 28 Jul 2008 07:11:29 -0700 (PDT)
Message-ID: <389c4f1d-71d0-4986-a1c2-644ad671952c@v39g2000pro.googlegroups.com>
Date: Mon, 28 Jul 2008 07:11:29 -0700 (PDT)
Message-ID: <389c4f1d-71d0-4986-a1c2-644ad671952c@v39g2000pro.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
- to what extent these statements are true ?
