Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2026 10:18 AM
I ran the query on a serverless warehouse and it was not a cold start because the warehouse was already up and running other queries. Even on a medium warehouse the query still takes about 40 sec. On the note of first query, if I run the exact same query again it is faster possibly because it gets cached. But if I do a lookup on another workspaceID it again takes 40sec to run the query. The table only has 2 rows for us and hence it is very surprising to see these simple queries take 40-50seconds. I also tried selecting only two fields instead of select *, but that doesnt change the time it takes