With ever increasing numbers of companies connected to Invantive Cloud through a subscription, there are often dozens, hundreds or even thousands of companies to select as a “partition” to run SQL queries across multi-tenant cloud applications.
The use statement facilitates power users with many companies to run queries across and in parallel, as illustrated on Improved Very Large Company Volume Performance on Exact Online.
Starting SQL users such as finance professionals will appreciate the new extended options to search and select partitions in the online SQL editor of Invantive Cloud.
For Exact Online, Twinfield, Yuki and alike, each company translates into a partition, and for instance for Loket or NMBRS, each payroll company is a partition.
