Can you explain why you can't just add primary key for the table? Every table -should- have primary key. It is even - funny thing, really - written in rule2...

Ross McMicken (3/18/2009)

---

Without knowing the structure of your bitmaps, but assuming there is a product ID or something similar for each row, can you change the table to have a...

I can redesign it completely.

To be honest - I'm not sure. I would say that on average there are...

It would be probably a lot slower without primary key in the table. And why you have no primary key in the table? Primary keys are strictly fundmental.

Let's see...

if...

--TO BE DELETED; SEE BELOW--

It would be probably a lot slower without primary key in the table. And why you have no primary key in the table? Primary keys are...

I don't think it has anything to do with text index.

It is a database of items which can be described with hundreds features. The features are ussually not correlated. Now...

While this solution is probably not the most efficient one, it should work provided you have some kind of row_id to know the difference between different rows.

DELETE FROM #pom WHERE...