Re: EXPLAIN result diff. in TEST and REALITY

In article <Pine.SCO.3.91.950721073842.5736A-100000@pali> pop116@ind.eunet.hu "programmer" writes: > > In our TEST DB the result of a joined query and SET EXPLAIN is INDEX PATH > for the two tables. On our REAL enviroment this result is for one table > is SEQUENTIAL SCAN, and for the other one is INDEX PATH. Is this normal ?? > The query is awful slow, maybe thatsway ?? The sequential scan will be why the query runs very slowly. Unless (unlikely!) your test & live dbs are IDENTICAL (size of tables, indexes, key distributions) there is nothing sinister about the same query producing different QEPs. Check the following: i) Indexes are identical ii) Run 'update statistics' on both dbs Hope this helps! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================