Hi,

> I have received 2 reponses:
>
> 1) Using the "Natural" plan, but it is not a solution. It is the problem
> that I have. I cannot use a natural plan in a database with millions of
> rows.
>

Well, you're looking at the problem the wrong way OR you didn't explain
it in enough detail: WHY would you want to potentially transfer millions
of rows in a resultset to your users?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com