We need the execution plan as a SQLPLAN file.

We also need the CREATE VIEW definition

We also need the CREATE TABLE definition of all the tables in the query and or view

We also need all the CREATE INDEX definitions of all the indexes on all the tables in the query

We also need the FULL SQL STATEMENT used when generating the execution plan.

Please follow the links in my signature, on posting performance problems and how to post code and data. Without this we cannot help you further.

Remember we cannot see what you can see.