Splunk Search

Using Fields Efficiently

peasead
Path Finder

I'm trying to get a search to run as efficiently as possible and a couple of the guys on my team have been going back and forth regarding the placement of the 'fields' syntax.

I have always put the 'fields' syntax immediately after my sourcetype, but some people put it in the middle of the search, some put it before/after the math that is done, some put it right before the 'stats', 'table', etc.

I looked in the documentation, but I didn't see anything saying that it should go "here" or "there".

Is there a preferred place to put the 'fields' syntax?

1 Solution

yannK
Splunk Employee
Splunk Employee

If you really want to go that way, use the search inspector (the "i" button) to see the search speed.
and run the same search on the same time window with several variations of your search.

View solution in original post

yannK
Splunk Employee
Splunk Employee

If you really want to go that way, use the search inspector (the "i" button) to see the search speed.
and run the same search on the same time window with several variations of your search.

peasead
Path Finder

Great idea.

As it turns out, it doesn't matter much.

0 Karma
Get Updates on the Splunk Community!

New Year. New Skills. New Course Releases from Splunk Education

A new year often inspires reflection—and reinvention. Whether your goals include strengthening your security ...

Splunk and TLS: It doesn't have to be too hard

Overview Creating a TLS cert for Splunk usage is pretty much standard openssl.  To make life better, use an ...

Faster Insights with AI, Streamlined Cloud-Native Operations, and More New Lantern ...

Splunk Lantern is a Splunk customer success center that provides practical guidance from Splunk experts on key ...