Strangely it works sometimes - I know that this should be that slow, the textfield is indexed - w/o duplicates - but i have used the same structure for other tables (with over 5 times as much data) and there it works..
Is it possible that indexing w/o duplicates causes this problems?
Originally posted by rnealejr
Which type of index are you using ? In your previous instances where you had no problems, did you have the index using the "without duplicates" option ?
In the troubled table i'm using index: w/o duplicates - in the not troubled table the row is indexed but with duplicates...
another problem is - I currently cannot change this, because I dont have enough space for the transaction log to save 15000-50000 rows (indexes)