Can I increase the performance of my queries?

No data is stored within the Cloud Data Fabric.

Every query will interrogate the source system to generate a result.

In some cases the one or more source system can have a very slow response time, causing the Cloud Data Fabric to wait for sufficient data to be received before other data source information can be referenced.

For slow responsive source systems it is useful to cache the data, so that the response is much quicker. Instead of referencing the table, view or file in the source systems, the cached copy can be used.

Reference on how to cache and uncache data can be found in the SQL Guide