Re: Slow checkpoints

In article <34C88F4A.867DB3A@bellsygma.com>, Normand Bedard <normand.bedard@bellsygma.com> writes >Hi, > I run a query on Informix On-Line 7.23UC2 and I go from >1 sec. checkpoints to 30 sec. checkpoints. Any explanations? >The table is partitioned and it is very large (46 million rows) >Any explanations? Can I avoid this situation? > >select count(*) total,count(*)*.75 percent >from fact where telz[5,12] = '555-1212'> Try running SET EXPLAIN ON in dbaccess then run the query.... You should get a n sqexplain.out file produced. What does it say? I expect that since you are searchin on the middle characters of a column that an index is not being used and it is scanning the whole table. Don't query on the middle of a column, instead break the column up into several columns. It look like you one column is really several pieces of information all joined together... -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care