Re: Let me be the first

Hi Lukas, Are you saying that you have 1 composite index on col1, and col2 ? Or are you saying that you have 1 index on col1 and 1 index on col2? For that matter, currently how large is each of your indices? Just trying to see if there is somethign else involved. ----- Original Message ---- From: Lukas Barton <lukas@cnawr.cz> To: Informix-list@iiug.org Sent: Monday, September 25, 2006 12:17:24 PM Subject: Re: Let me be the first - http://docs.rinet.ru/InforSmes/ch15/ch15.htm ( For an index, three more locks are necessary--one lock for the accessed row, one for the row before the accessed row, and one for the row after the accessed row) Which version of IDS does this refer to? In any event, I never realised I was this lucky before. <preen> Maybe I'll enter the Lottery this weekend. I use IDS 10.0 on Windows. Here is statement sequention to demonstrate my problem: Thread1: UPDATE TABLE table1 SET col1=10 WHERE col2=15; .... further processing for 10 minutes.... Thread2: SELECT * FROM TABLE table1 WHERE col2=20; (locked until thread1 finished). There is index on col1 and col2. Lukas _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list