System table missing primary keys?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2026 03:06 PM
This simple query takes 50seconds for me on a X-Small warehouse.
select * from SYSTEM.access.workspaces_latest where workspace_id = '442224551661121'
Can the team comment on why querying on system tables takes so long? I also dont see any primary keys set on this table, is that intentional?
