Re: Strange user request on ordering data

From: wayne <no_at_email.please.com>
Date: 16 May 2001 01:54:08 GMT
Message-ID: <9dsmk0$5m3@dispatch.concentric.net>

> the table in based on a certain column. The only way I can think of
> doing this is to create a view over the table with the proper order by
> methodology.

Absolutely right. Views and stored procedures can be seen as the bridge between what users ask for (usually unreasonable) and what a DBA needs to do to make the DB run right.

Yes, create the views, add the right indices, and use the ORDER BY clause in the views. Received on Tue May 15 2001 - 20:54:08 CDT