PHWinfo - Afficher un message - Ordering of table rows before selection (optimization problem)

05/02/2008, 11h29

On 5 Feb, 00:46, Kurda Yon <kurda...@yahoo.com> wrote:
> > Create an index holding your chosen value
>
> Do you mean "primary key"? The problem is that the column declared
> with the primary key should hold _unique_ values. In my case, some
> rows can have the same value of the argument which I want to use for
> the ordering.

No, I mean create an index. An index can be a unique or a non-unique
index.

05/02/2008, 11h29	#6
Captain Paralytic Messages: n/a Hébergeur:	Re: Ordering of table rows before selection (optimization problem) On 5 Feb, 00:46, Kurda Yon <kurda...@yahoo.com> wrote: > > Create an index holding your chosen value > > Do you mean "primary key"? The problem is that the column declared > with the primary key should hold _unique_ values. In my case, some > rows can have the same value of the argument which I want to use for > the ordering. No, I mean create an index. An index can be a unique or a non-unique index.