Try our new research platform with insights from 80,000+ expert users

Amazon Redshift vs Oracle Autonomous Data Warehouse comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
6th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
71
Ranking in other categories
No ranking in other categories
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
10th
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.5%, down from 8.0% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 5.0%, up from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Sriram-Natesan - PeerSpot reviewer
The ability to create a lot of views or materialized views is beneficial
Improvement in the immediate response and the process of getting into a call could be helpful. We have had to wait for at least twenty-four hours to get a call and then wait for a couple more hours for a solution. Improved connectivity to different BI tools and already published connectors for major tools in AWS could enhance the service.
Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"It is quite simple to use and there are no issues with creating the tables."
"Its simplicity in configuration, cost-effectiveness due to being in the cloud and close to our data sources, and the fact that it's a managed service that is scalable and reliable are highly valuable."
"The initial setup is easy."
"The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"Redshift Spectrum is the most valuable feature."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"It is a stable and scalable solution."
"It is a very stable tool...It is an extremely scalable tool."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"Self-patching and runs machine-learning across its logs all the time"
 

Cons

"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"It would be good to see Redshift as a serverless offering."
"The customer support could be more responsive."
"It takes a lot of time to ingest and update the data."
"The solution is unable to work fast."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The solution could improve in handling more data formats and more native support for RDF."
"A lot of the tools that were previously there have now been taken away."
"Optimization should be better."
"The setup is complex."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"I would like to see an on-premise solution in the future."
"Ease of connectivity could be improved."
"The initial setup was pretty complex. It was not easy."
 

Pricing and Cost Advice

"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"The product is quite expensive."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"Pricing for Amazon Redshift is reasonable, though it could be somewhat higher than other solutions, such as Azure. Still, when you base your comparison on the services offered and the pricing, it's the most reasonable versus its competitors, such as RDS."
"The cost is comparable to Snowflake."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"The cost is perfect with Oracle Universal credit."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The price depends on the configuration we choose."
"The solution's cost is reasonable."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"ROI is high."
"The solution is expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,957 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
35%
Financial Services Firm
12%
Computer Software Company
10%
Manufacturing Company
6%
Educational Organization
23%
Financial Services Firm
11%
Computer Software Company
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?
We pay approximately $70,000 per month. The cost includes maintenance and support.
What needs improvement with Oracle Autonomous Data Warehouse?
Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not supported, which is not ideal.
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about Amazon Redshift vs. Oracle Autonomous Data Warehouse and other solutions. Updated: June 2025.
859,957 professionals have used our research since 2012.