Please see my update in my sheet. Header: Number of indexes better to have in each table Having more indexes, will certainly slow down the INSERT, UPDATE action on the tables. How to judge this, on 10g database? Is it a better choice to have 4/5 indexes only? Chen,What do you mean by syntax ?...