HELP: SQL query using condition LIKE
From: Liang Lin <llin_at_uv1.med.umich.edu>
Date: 3 Nov 1993 16:03:46 GMT
Message-ID: <2b8kp2$qkp_at_terminator.rs.itd.umich.edu>
Date: 3 Nov 1993 16:03:46 GMT
Message-ID: <2b8kp2$qkp_at_terminator.rs.itd.umich.edu>
When I use SELECT...LIKE on an indexed column, it's almost 10 times slower than SELECT...=. Is there any way to improve the performance while still using SELECT...LIKE?
Thanks.
Liang Lin Received on Wed Nov 03 1993 - 17:03:46 CET