Hi I have a table with 4 million records,35 fields. A primary key field. Every 1 hours 1000s or 10000s of records inserting in this table using bulk insert. I have report in my web application querying 25 fields including the primary key field. But while querying the primary key field then the result pretty fast. But quering the non-indexed field then the process dead slow. So that I created an indexed view with all the 25 field. Then set the clusterted index and the non-clustered Index for 24 field. Then my all the query are Good fast. Now I expirencing that, the insersion in the base table is too slow. I doubt the indexed view ( bcz SQL up-to-date the indexed view too while insersion happen in the base table - I think it takes time to up-to-date) So drop the indexed view. Now my all the queries gets slow. I don't know What I do next? Can I set the non-clustered index to all the 24 fields.(Querying fields) in the base table itself.? Will it leads any problem mentioned above.? Please suggest me. Thanks in Advance Ganesh.