Hi

My actual situation is rather complex, so I'll try to reduce it to its
component parts.

If I execute a select along the lines of

select * from sometable where indexedfield=99

then its quite quick (about 0.2 second) even getting 400 rows from 80,000

If I create a view of the same then its equally quick.

However, if I create a view of the SELECT without the WHERE clause

then do

select * from myview where indexedfield=99

Then it takes upto a minute.

Is there anything I can do to improve performance, since clearly its the
latter example that I need in my application.

Cheers

Rob