tag:blogger.com,1999:blog-2638172220204338809.post790685214893216126..comments2023-12-20T02:37:08.459-05:00Comments on Yiyu Jia's technical Blog: Why does DB2 not use Index I created?!Yiyu Jiahttp://www.blogger.com/profile/04493914593695340001noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2638172220204338809.post-82038630886237279372012-04-18T12:03:53.228-04:002012-04-18T12:03:53.228-04:00Hi Yiyu Jia,
Do you know why when i selected a co...Hi Yiyu Jia, <br />Do you know why when i selected a column with BLOB datatype, all my access path was kill by system. <br />Following each access path name in the list is a reason code which explains why the access path was not used. A reason code of 0 indicates that the access path was used to implement the query. <br /><br />1 - Access path was not in a valid state. The system invalidated the access path. <br /><br />I had tested all possible method such as reorg, create a new table (blank table) & index, the run Visual Explain to see the log. It still the same. If my sql statement exclude that field then my log appear as normal (will use the primary key/index).<br /><br />4 - The cost to use this access path, as determined by the optimizer, was higher than the cost associated with the chosen access method. <br /><br /><br />Do you have any idea on setting up the optimizer for BLOB?Alex C.https://www.blogger.com/profile/03947384219480129140noreply@blogger.com