QUESTION POSED ON: 24 July 2006
I have a question about index performance. This is my scenario: Table A consists of 10 columns. Col1 is the primary key. I have three indexes
for Table A: IDX1 consists of Col2, IDX2 consists of Col1, Col3, Col4 and Col5 and IDX3 consists of Col4, Col5, Col6 and Col7. These
indexes are helpful when I perform select statements, especially for SQL involving GROUP BY. Will these indexes affect the performance on updates and inserts for Table A? Without these indexes, the select statements are causing a lot of problems in performance and are thus resulting in high-cost execution and elapsed time is high.
Table A
---------
Col1 PK
Col2
Col3
Col4
Col5
Col6
Col7
Col8
Col9
Col10
Thanks and regards.
|
