All Apps and Add-ons

Error in 'noop' command : invalid argument:'search_optimization'

bestSplunker
Contributor

I am trying to optimize the query speed of the db connect app. I have read the following post, it tell me I can use | noop search_optimization=false, but splunk return an error when I using.

Error in 'noop' command : invalid argument:'search_optimization'

this my search :

|noop search_optimization = false|dbxquery connection="connectTestDB" query="select * from clientData"

I also tried to add | noop search_optimization=false at end of dbxquery ,errors remain

0 Karma

woodcock
Esteemed Legend

You are doing it wrong; put it at the end like this:

|dbxquery connection="connectTestDB" query="select * from clientData"
| noop search_optimization=false
0 Karma

bestSplunker
Contributor

@Noah_Woodcock I don't know why. it haven't thrown an error now,but it didn't speed up the search

0 Karma

woodcock
Esteemed Legend

It is not supposed to speed up the search. It is supposed to slow it down and make it simpler. What do you think that this is supposed to do? In any case, my answer solved your problem so you should click Accept and move on and ask another new/different question, rather than diverge this one:
https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Noop

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What version of Splunk are you running?

---
If this reply helps you, Karma would be appreciated.
0 Karma

bestSplunker
Contributor

@richgalloway 7.2.3

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...