Re: Using LIKE with indexed column
From: TSChqisten <tschqisten_at_aol.com>
Date: 1995/04/21
Message-ID: <3n7bbe$esm_at_newsbf02.news.aol.com>#1/1
Date: 1995/04/21
Message-ID: <3n7bbe$esm_at_newsbf02.news.aol.com>#1/1
I believe that indexes are NEVER used in a LIKE, because
the full text of each index entry is stored in the index
and oracle isn't prepared to deal with a partial index search within
a column.
The same rationale applies when trying to select on
a substringed column - the index won't be used.