SQL Server Performance Forum – Threads Archive

delete from with(index)

Hello,
I am trying to run this query: delete from carton with(index(idxviadatetimelasttrans)) where datetimelasttrans < ‘2002-11-11’ I keep getting the error "index hints are only allowed in a from clause". Is there any way to hint what index to use in a delete statement? Thanks, Ben

---

If my memory serves me right (sitting here at home) the following should be working: delete carton
from carton with(index(idxviadatetimelasttrans))
where datetimelasttrans < ‘2002-11-11’

---

Sitting in home without BOL I gess Boutwater delete is Ok.
Try using SQL Analyzer, Tools, Index managment, look at carton table, find Index and try to deleted.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

]]>