http://www.dbatodba.com These are the search results for the query, showing results 1 to 2. http://www.dbatodba.com/Forums/db2/896465072/572881739 I need to select the registers that ends with 1 Example: Select number from Table where MOD(number, 10) = 1 Supose I have an index for number's column. When I use the MOD function the database does not use the index so I changed to SELECT number from table where (number - (number/10) * 10) = 1 That is the MOD formula. For the same reason the database does not use the index. I looked on net and found that on Db2 ZOS is possible to use index based on functions. Is this possible to DB2 9.7 Linux? Thanks No publisher breno 2011-03-24T22:05:59Z Comment http://www.dbatodba.com/Forums/db2/154590044/298404926 What's the best alternative for selecting huge data and making it available to use in a cursor?   (PL/SQL Db2 9.7) I have also tried using MQT's. No publisher breno 2011-03-16T17:30:24Z Comment