> -Original Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 11:11 AM
> To: Salada, Duncan
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: help with index/query
>
>
> what about
> select Url from table where Ref = &#x
what about
select Url from table where Ref = 'foo'
Salada, Duncan wrote:
>I am hoping I can get some help with a difficulty I am having with a table
>of mine. I am going to give a lot of background info, so please bear with
>me. First, let me say that I using 3.23.49. Now some info about the
Just make sure you have a key on any field you do a query on. Given that
there isn't a whole lot of correlation between your columns (logically
speaking.. ie, age doesn't really match up with city) I wouldn't worry
about compound keys.. they'll actually just slow you down since you need
to mainta
>> whats the difference between:
>> alter table tablename add index (name);
>> alter table tablename add index (age);
>> alter table tablename add index (birthdate);
>> alter table tablename add index (city);
>
>These are four INDIVIDUAL keys.. helpful if you want to search by name,
>age, birthday
> whats the difference between:
> alter table tablename add index (name);
> alter table tablename add index (age);
> alter table tablename add index (birthdate);
> alter table tablename add index (city);
These are four INDIVIDUAL keys.. helpful if you want to search by name,
age, birthday, _OR_
