Advice on Indexes please?
From: harry <a_at_abc.com>
Date: Wed, 07 Nov 2001 10:39:29 GMT
Message-ID: <dj3iuto2j3uucoa7ms9li9o3vkmdhvdt3t_at_4ax.com>
Date: Wed, 07 Nov 2001 10:39:29 GMT
Message-ID: <dj3iuto2j3uucoa7ms9li9o3vkmdhvdt3t_at_4ax.com>
In general should any columns that appear in a WHERE clause have a index created for them?
Also should the same rule apply if they appear in the ORDER BY part aswell?
harry Received on Wed Nov 07 2001 - 11:39:29 CET