alternative to select distinct syntax

Hi,

I have a query which joins 5 tables and returns about 1 Mio records including duplicates.
When i use a "select distinct" it returns about 5000 records.

Obviously a large unique sort is taking place and this is taking a long time
about 10 mins. When i remove the distinct clause the query is instant.
Are there any alternative syntax to getting this query to run fast? Does this db have a normalisation problem?

ps ( The sort area size is already really large)

thanks
Kelvin Received on Mon May 26 1997 - 00:00:00 CDT