RE: ORDER BY when selecting a TEXT type column uses disk based temp table

2002-04-01 Thread Robert V. Zwink
disk based temp file? This only seems to occur when the TEXT type field is greater than 255 characters. You can find the complete query below. Thanks, and sorry for the re-post. Robert Zwink http://www.zwink.net/daid.php -Original Message----- From: Robert V. Zwink [mailto:[EMAIL PROTEC

ORDER BY when selecting a TEXT type column uses disk based temp table

2002-04-01 Thread Robert V. Zwink
r text based columns? I'm not sorting by the TEXT column, I'm actually sorting by an INT column. Thanks for any help you might be able to offer. Robert V. Zwink http://www.zwink.net/daid.php - Before posting, please check: