Performance issue while select from view..

[WilliamR]

Unfortunately it is very hard to tune an SQL statement without knowing a great deal of background information about the data and the purpose of the query. The execution plan is helpful, although it would be more readable if you could format it in [code] tags to preserve indentation.

The best thing to try first is to make sure all the tables involved have been analyzed and see what the optimizer makes of it. If you think it is using an inefficient approach, figure out what it's doing wrong and what information it might be missing to cause that.

Any performance issue you may have is unlikely to be caused by the view itself.

btw what is the purpose of WHERE 1=1?