Here's the situation:
Query: Bro * from prodview where unit_no='1709' and grade='1215' Results in a few seconds against 7.5 database with 490,305 rows Results 10+ minutes and waiting from 8.0 database upgraded from previously mentioned 7.5 database (only with 171,000 fewer records) All things being equal, table structures, indexes and view structures are the same between both versions. Using a SELECT statement gives decent results in both versions but the BROWSE just dies in V-8. Interestingly if I set MANOPT ON then I get similar BROWSE performance between both versions. Why is there such a difference between the versions and more importantly what can I do about it? Is it better to run with MANOPT ON? Thanks for any feedback. Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340
