On 1 Aug 2006 at 15:23, bill_lam wrote:

>Does FB have clustered index to improve index performance? AFAIU FB
>have PK as a contraint but does it imply PK=clustered index?

FB does not have clustered index. Tables in FB database are
normally fragmented. Defragmentation would make things slower.
For every PK constraint FB creates an unique index and usually it
is more than enough.

--
SY, Dimitry Sibiryakov.