# Set the index field to be not\_analyzed and then do wildcard query, does it appear low performance?

**URL:** <https://discuss.elastic.co/t/set-the-index-field-to-be-not-analyzed-and-then-do-wildcard-query-does-it-appear-low-performance/11326>\
**Category:** Elasticsearch\
**Created:** [March 27, 2013, 1:43am UTC](https://discuss.elastic.co/t/set-the-index-field-to-be-not-analyzed-and-then-do-wildcard-query-does-it-appear-low-performance/11326 "2013-03-27T01:43:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hoony](https://avatars.discourse-cdn.com/v4/letter/h/7ab992/32.png) [@Hoony](https://discuss.elastic.co/u/Hoony)\
**Post date:** [March 27, 2013, 1:43am UTC](https://discuss.elastic.co/t/set-the-index-field-to-be-not-analyzed-and-then-do-wildcard-query-does-it-appear-low-performance/11326/1 "2013-03-27T01:43:27Z")

</div>

HI,  
Set the index field to be not\_analyzed and then do wildcard query, does it  
appear low performance? ......Are there any issue to lead it appear low  
performance????

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![radu\_gheorghe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/radu_gheorghe/32/556_2.png) [@radu\_gheorghe](https://discuss.elastic.co/u/radu_gheorghe)\
**Post date:** [March 27, 2013, 2:00pm UTC](https://discuss.elastic.co/t/set-the-index-field-to-be-not-analyzed-and-then-do-wildcard-query-does-it-appear-low-performance/11326/2 "2013-03-27T14:00:57Z")

</div>

Hello,

Wildcard queries are typically slower than non-wildcard queries. And if you  
have a leading wildcard, it's going to be even slower.

The other option is to tweak your  
analysis[http://www.elasticsearch.org/guide/reference/index-modules/analysis/](http://www.elasticsearch.org/guide/reference/index-modules/analysis/)settings  
for your documents and queries.

## Best regards, Radu

[http://sematext.com/](http://sematext.com/) -- Elasticsearch -- Solr -- Lucene

On Wed, Mar 27, 2013 at 3:43 AM, Hoony [monkeyboywon@gmail.com](mailto:monkeyboywon@gmail.com) wrote:

> HI,  
> Set the index field to be not\_analyzed and then do wildcard query, does it  
> appear low performance? ......Are there any issue to lead it appear low  
> performance????

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:44am UTC](https://discuss.elastic.co/t/set-the-index-field-to-be-not-analyzed-and-then-do-wildcard-query-does-it-appear-low-performance/11326/3 "2017-07-06T02:44:10Z")

</div>