OAS Timeseries Functions Performance Is Slow Against Snowflake Datasource
(Doc ID 2738279.1)
Last updated on DECEMBER 23, 2020
Applies to:Oracle Analytics Server - Version 184.108.40.206.201012 and later
Information in this document applies to any platform.
Performance issues are seen on Timeseries functions against a Snowflake data source, when compared to an Oracle data source. Both tests were performed on the same server with the same amount of memory.
Steps To Replicate:
- Log in to the RPD and create connection for Snowflake and Oracle DB.
- Create the columns from analysis using the time series function on both the DB's.
- Observe that the performance issues are seen on Snowflake data source.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document