I am working as DBA and doing some optimization jobs. I found the long running queries. These queries call views(joins more than two tables) and executes the result. When I execute queries, the execution plan shows Index scan, Clustered index scan in participating tables. I also execute the SQL statements of the views, this also show, same nature of execution plans(index scan, clustered index scan). Is it necessary to remove scans from views first or can remove scans from query directly ? why clustered scan/index scan happens evenif there are indexes in join columns, where clause, orderby clause ? Please send me your kind answers soon.