| Subject | Re: when an index is needed ? |
|---|---|
| Author | Sergio |
| Post date | 2012-01-31T14:46:24Z |
--- "Leyne, Sean" <Sean@...> wrote:
...but in that case, wouldn't you have a FK to the country table? Do you mean that in such case we should avoid the use of the index doing something like
select
*
from
persons
where
id_country = :id
or
1 = 1
Sorry If I didn't get your idea correctly!
-s
> Consider, A table with every person in the world:Hi!
> - it also not have an index for Country (China + India = 25% of database)
...but in that case, wouldn't you have a FK to the country table? Do you mean that in such case we should avoid the use of the index doing something like
select
*
from
persons
where
id_country = :id
or
1 = 1
Sorry If I didn't get your idea correctly!
-s