You can create effective queries with domain paths.

Use domain paths instead of domain spooling (sys_domain) or domain numbering. Queries that use domain paths are much faster than spooling or numbering.

Domain paths is the default query method for instances that have enabled domain separation.

If you want to verify the query method on your instance, look for the following system properties in the admin dashboard:
  • If domain path is enabled: In the System Properties table, you see glide.sys.domain.provider=domain_paths and glide.sys.domain.paths.installed=true.
  • If domain path is not enabled: In the System Properties table, you see glide.sys.domain.provider != domain_paths,glide.sys.domain.paths.installed=false