开发者

Index for efficient full text search using "LIKE" syntax

开发者 https://www.devze.com 2023-04-13 03:55 出处:网络
I have an applicatio开发者_开发知识库n which sends queries like the following to the database:

I have an applicatio开发者_开发知识库n which sends queries like the following to the database:

x like '%abc%'

I can't modify these queries, but I can index the underlying tables. Is there any way to put a full text index on a table such that double open-ended like queries can be performed without a full scan?


No, there is no way to make LIKE predicates with wildcards avoid a table-scan so they perform well for full-text search. You must use Oracle Text features and modify your queries to use text-searching predicates.

See Oracle® Text Application Developer's Guide

0

精彩评论

暂无评论...
验证码 换一张
取 消