# Running a query with where clause which has one tag and one field

**URL:** <https://community.influxdata.com/t/running-a-query-with-where-clause-which-has-one-tag-and-one-field/30019>\
**Category:** InfluxDB 2\
**Tags:** influxdb\
**Created:** [May 20, 2023, 12:51pm UTC](https://community.influxdata.com/t/running-a-query-with-where-clause-which-has-one-tag-and-one-field/30019 "2023-05-20T12:51:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jaychandran\_subraman](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jaychandran_subraman/32/9322_2.png) [@jaychandran\_subraman](https://community.influxdata.com/u/jaychandran_subraman)\
**Post date:** [May 20, 2023, 12:51pm UTC](https://community.influxdata.com/t/running-a-query-with-where-clause-which-has-one-tag-and-one-field/30019/1 "2023-05-20T12:51:11Z")

</div>

An influx measurement has 2 million record. It consist of 4 tags and 8 fields. I am running a query with where clause which has one tag and one field. The query result is 1000 records and it’s taking 4 seconds

---

<div class="post-metadata">

**Author:** ![grant1](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/grant1/32/15107_2.png) [@grant1](https://community.influxdata.com/u/grant1)\
**Post date:** [May 20, 2023, 2:26pm UTC](https://community.influxdata.com/t/running-a-query-with-where-clause-which-has-one-tag-and-one-field/30019/2 "2023-05-20T14:26:29Z")

</div>

Flux or InfluxQL? Can you post your query here?

---

<div class="post-metadata">

**Author:** ![jaychandran\_subraman](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jaychandran_subraman/32/9322_2.png) [@jaychandran\_subraman](https://community.influxdata.com/u/jaychandran_subraman)\
**Post date:** [May 20, 2023, 4:30pm UTC](https://community.influxdata.com/t/running-a-query-with-where-clause-which-has-one-tag-and-one-field/30019/3 "2023-05-20T16:30:30Z")

</div>

Thank you for your response!  
Its timeseries Influx DB . PF below query  
Select \* from where = ‘abc’ and = ‘xyz’