SV: [Phpgroupware-developers] SQL Style Guide available

[Sigurd Nes]

> 6. Defining indexes
> 
> Indexes will speed up the processing of select statements when they
are
> set
> correctly.
> In database systems without real "foreign keys/relations" (like MySQL
3.x)
> you should create
> an index for each key that references another tables.
> Otherwise MySQL will do a cost intensive full table scan each time.
> You also should create indexes for often used select statements.
 

Just a note:
The creation of indexes and foreign keys seems not to be implemented in
the setup - although there is set placeholders for them in
'tables_current.inc.php'
        'pk' => array(),
        'fk' => array(),
        'ix' => array(),
        'uc' => array()

Sigurd