Re: Using LIKE with indexed column
From: S. Kannan <skannan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1995/04/20
Message-ID: <3n6062$bqo_at_cardinal.fs.com>#1/1
Kannan
Email: skannan_at_fs.com
Received on Thu Apr 20 1995 - 00:00:00 CEST
Date: 1995/04/20
Message-ID: <3n6062$bqo_at_cardinal.fs.com>#1/1
: It the index used to find the record?
In this case since the % is trailing, I believe the index is being used.
However, if you have a % leading (like '%doody%') the index will not be
used.
Kannan
Email: skannan_at_fs.com
The above are my own comments and opinion. They do not purport that of anybody else.
Received on Thu Apr 20 1995 - 00:00:00 CEST