you have to post view definition, indexes on all tables, explain plan, number of rows of each table

a simple sql stmt is not enough?