You can run SQL queries as background search sweeps. As the name suggests, the queries run in the background, and so you can run time-consuming queries without inconveniencing your use of the system. These queries are also intended to support a wide variety of reports, such as chargeback, capacity planning, business unit, and document age and usage reports.
A background search query can optionally retrieve data from another object store. This feature allows the processing load and search result storage to be isolated from the production database.