Hi friends, I have one table with 34 columns. We are importing data from a flat file thru Bulkinsert. After that we need to delete some rows which contains 25 columns are ALL ZERO from the table which takes lot of time. The table has no indexes. How to optimize the delete operation. Any idea? In Oracle they have some Function based indexes. Here in sql server I beleive we don't have such type. Any idea to optimize the delete operation? Thanks in advance.