Of cause sometimes i use wildcards in this query.
That's the reason i use like instead of =.


Steffen Heil schrieb:

>
> Hi
>
>
> One way to speed up things would be to use = instead of LIKE if possible:
>
> > SELECT DISTINCT * FROM t_apos JOIN t_auftrag on f_id_auftrag
> > = id_auftrag WHERE f_liefer_nr = ?
>
> This should be as fast as your second example and as flexible as your
> first
> example as long as you don't use wildcards.
>