Problem with complex select/IDS 7.31.UC3 & statistics

Hi, I'm just playing around with a testing environment because we're facing a weird problem. We've got IDS 7.31.UC3 running on a Solaris 2.6 box; after issuing a complex select statement with several tables (some of them outer joined) we're getting a result set of 73 rows though we were expecting only one row (which is correct, because the 73 rows IDS provides are completely identical!)! This doesn't happen on 7.23.TC14 (NT4/SP4) and 7.24.UC5 (Solaris 2.6). Now, I've set up a small database only with the tables used in the select and loaded the data to achieve the correct result set. The first try succeeded and the select delivered one row! After wondering why it worked this time I set up the statistics (low w/ drop distributions) and I retrieved 73 rows! Now, maybe somebody out there encountered the same problem and, btw, how can I get rid of the statistics completely for testing purposes because dropping and creating the database over and over again doesn't make me happy... ;-) TIA and many regards, Stephan. -- Stephan Stresing MR Informatik GmbH mailto:st@mr-informatik.de Sent via Deja.com http://www.deja.com/ Before you buy.