Is it possible to create 10K columns in questdb? If yes, what is the efficient way to query them?

Seems you can have up to 2 billion columns: https://questdb.io/docs/reference/sql/create-table/#column-name

I am doing a

select * from <tableName> where time >= lowerValue and time <= upperValue

the query giving response in 1 minute for 1 hour of data

hola Bishnu, would you please describe your use case?, how are you using QDB?, volume of data?, why do you need this level of cardinality?, ta

is the

time

column created as a designated timestamp? https://questdb.io/docs/concept/designated-timestamp/

hola @Bishnu this will help https://questdb.io/blog/sql-performance-tuning-introducing-explain/