Re: Help on Indexes!

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: Sun, 17 Jan 1999 22:38:32 +0800
Message-ID: <77v67e$2s2$5@news.seed.net.tw>

Adrian Harrison ¼¶¼g©ó¤å³¹ <369f2f85.5110979_at_news.globalnet.co.uk>...
>I have a table with 2 fields "ID, Name"
>I want to be able to search on them both together & individually!
>Do I have to create 3 indexes i.e on ID, Name, ID&Name or will just the one
>ID&Name work?

You can search all 3 ways by creating 2 indexes as follows

index1 on (col1,co2), index2 on (col2)
or just
index1 on (col1), index2 on (col2) Received on Sun Jan 17 1999 - 08:38:32 CST