Without supplying the queries you want to perform against the table,
and your current index in DDL format you will not get much help.
As you say updates are infrequent there is nothing (well maybe disk space)
to prevent you going wild and adding covering indexes for every query you
will ever run (up to 249).
Looking at the execution plan ( Query yser ) for your queries will show
you where you need more indexes, or you could use the index tuning wizard.
Supplying DDL - ie "Create Table ..." code by scripting your table
( <right click> <all tasks > ... from Enterprise Manager ),
including indexes may get you a better answer.
"fabriZio" <it> wrote in message news:phx.gbl...