SQL Tunning using Indexes

Are there any ways or initial parameter to make parallel query on index scan and retain single query on insert, update?

From previous experience, we can parallel query using index by using HARDCODED hints or change the degree of the index (it must be partitioned) However, if an insert or update is performed on the table and make the index grow beyond its available space. Instantly, several extends (same as the index's degree) would also be producted instead of 1 extends at a time. If we use degree 1 for the index, then index scan would possibly need about 20 - 200 times lower than table scan.

Do anyone got the same experience and/or share your opinions?

Thanks in Advance! Received on Thu Nov 23 2000 - 08:43:24 CST