> Don't know about ALTER TABLE, but having native corelated subqueries > support would save on code and possibly speed up getting at > the end result greatly.
With other products, I've actually found that using temporary tables can yield definite performance increases that far outweigh the development cost involved. Using temporary tables, one can specify indexes that will help find the rows one is looking for. Other optimizations are possible as well, such as using the same temp table in more than one place, eliminating the need to execute multiple, almost identical, subqueries. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
