Hello List, When SQL is executed against a table that has one or more indexes defined against it, what type of locks, if any, are taken on the index? What type of index locking, if any, needs to be considered when SQL is executed against tables that have indexes defined on them? I looked in the Administration Guide : Performance manual at the lock mode table section and it shows the different locks that are taken based on table scans and various different index accesses. Regarding the different index accesses section, I am confused whether this is describing the locks taken on the table or locks taken on the indexes.
Any input on this would be appreciated. Thanks, Tim Traxson - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
