[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: mysql-win32: Index and Upgrading
From:       ashley pestkowski <ashley () design ! net ! uk>
Date:       1999-02-10 16:27:32
[Download RAW message or body]

Hello,

Clustered indexes specify that the table is physically ordered as-per
the index keys. This means that you need one less level of nodes in
the index b-tree. Due to the physical ordering a table can obviously
only have one clustered index declared on it. Clustered indexes are
especially useful if the keys match the column list in an ORDER BY
clause of a query.
Non-clustered indexes are regular indexed that do not affect the
actual ordering of the table. You can specify multiple non-clustered
indexes on a table.


> Hi!
> 
> Pray, what are clustered indexes. We have primery keys, unique, non
> unique and segmented indexes. Clustered ??
> 
> Within 3.22.xx you can safely use old database files.
> 
> Sinisa
> 
>


-----------------------------------------------------------
Send a mail to mdomo@tcx.se with
unsubscribe mysql-win32 your@subscription.address
in the body of the message to unsubscribe from this list.

[prev in list] [next in list] [prev in thread] [next in thread]