Hello everyone, Do dateTimeFieldSpecs columns have range index by default or do i have to define it in table configuration? in my use case, i am filtering on dateTimeFieldSpecs column and wonder if range index would make it faster?

Not by default, you need to set them. What’s the query and response metadata ?

i see this on broker log

requestId=546,table=mytable,timeMs=895,docs=1023803/283764030,entries=26491/4095212,segments(queried/processed/matched/consuming/unavailable):286/5/5/1/0,consumingFreshnessTimeMs=1663330739888,servers=5/5,groupLimitReached=false,brokerReduceTimeMs=186,exceptions=0,serverStats=(Server=SubmitDelayMs,ResponseDelayMs,ResponseSize,DeserializationTimeMs,RequestSentDelayMs);pinot-server-1_O=0,5,403,0,1;pinot-server-0_O=0,4,403,0,1;pinot-server-0_R=0,707,8000540,2,1;pinot-server-2_O=0,2,403,0,1;pinot-server-3_O=0,9,403,0,1,offlineThreadCpuTimeNs(total/thread/sysActivity/resSer):0/0/0/0,realtimeThreadCpuTimeNs(total/thread/sysActivity/resSer):0/0/0/0,query=select lat, lon, alt, msgTime from mytable where msgTime >= 1663244283950 and msgTime <= 1663330683608 order by msgTime limit 250000 option(timeoutMs=120000)

I meant the response metadata returned with query result, also the query