Re: Yes, this is probably a stupid question but...
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 15 Apr 2008 10:09:05 +0200
Message-ID: <480462a9$0$14348$e4fe514c@news.xs4all.nl>
Date: Tue, 15 Apr 2008 10:09:05 +0200
Message-ID: <480462a9$0$14348$e4fe514c@news.xs4all.nl>
Just another "probably stupid" question:
Unfortunaltely, my testdatabase could not handle the test scripts (it's sized too small I think) but would reversing the columns in
CREATE UNIQUE INDEX T1_IND1 ON T1(ACTIVE,SYS_ID); to
CREATE UNIQUE INDEX T1_IND1 ON T1(SYS_ID,ACTIVE); do some good here? (Since active is not very discriminating and the join is on SYS_ID)? Would like to have tested this myself, but no success...
Shakespeare Received on Tue Apr 15 2008 - 03:09:05 CDT