Hi
I tried to create an index on one of my tables.
After creating this index, the queries return an empty set, instead of the
expected result.
I have a table user looks like this:
id - int(11)
username - varchar(250)
address - varchar(250)
more columns...
After creating an index:
CREATE INDEX m
> -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
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 table.
It currently has 5687391 rows. There are 3 columns in the table: ID (i
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_
Hi,
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);
compared to:
alter table tablename add index (name,age,birthdate,city);
What I want is performa
