Re: index
From: Evan Keel <evankeel_at_sbcglobal.net>
Date: Mon, 28 Jul 2008 14:58:41 -0400
Message-ID: <xHojk.5904$np7.5044_at_flpi149.ffdc.sbc.com>
Date: Mon, 28 Jul 2008 14:58:41 -0400
Message-ID: <xHojk.5904$np7.5044_at_flpi149.ffdc.sbc.com>
<aarklon_at_gmail.com> wrote in message
news:389c4f1d-71d0-4986-a1c2-644ad671952c_at_v39g2000pro.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) to what extent these statements are true ?
Think about it.Physically true. Received on Mon Jul 28 2008 - 20:58:41 CEST