如何有效地搜索 [英] how to effectively search

问题描述

我的页面中有一个Radgrid。 RadSearchBox用于搜索和过滤Radgrid。当我在表中的firstname，middilename和lastname列中使用'LIKE％name％'编写SELECT查询时，如何提高性能。索引会帮助我吗？



例如：SELECT * FROM name_details where first_name LIKE％ram％OR last_name LIKE％ram％;



谢谢，

Amrutha

Hi,

I have a Radgrid in my page. A RadSearchBox is used to search and filter the Radgrid. How can i increase the performance when i write the SELECT query with ' LIKE %name%' in firstname , middilename and lastname column in my table. will indexing help me here?

eg: SELECT * FROM name_details where first_name LIKE %ram% OR last_name LIKE %ram%;

Thanks,
Amrutha

推荐答案

喜欢不使用普通索引，可以使用全文索引。

Like does not make use of normal indexes, it can use full text indexing.

这篇关于如何有效地搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！