[Theforum] Re: Changes to the VotingReqs document

Warden, Matt mwarden at mattwarden.com
Tue Feb 5 16:44:20 CST 2002


madhu wrote:
>>No .. the table itself can't be (to the best of my knowledge).
>
>Clustered index? Those physically rearrange the data, and you can only
>have one per table. (Do they have that in Oracle?)

indeces and tables are apples and oranges (respectively), my friend. in
fact, one of the benefits of an index is that the SQL server may not have
to look in the table at all (if your select list happens to be the
field(s) indexed).

and, ya, oracle has them

--
mattwarden
mattwarden.com




More information about the theforum mailing list