-
Oracle Exadata performance issue with simple select query
I am using Oracle Exadata cloud environment. I have a table which I am using to store raw data from excel import through an application. All the columns are VARCHAR2(100 CHAR). I have a simple select statement which returns all the records which are failed validation. In the application I am using OracleDataReader to fetch the records. This query takes about 15 minutes to return 308K records. I ran the statistics & are as below. I have a combine index on Batch_Id & User_Id columns. What can be done to improve the performance, this is a very simple select statement without any joins.
Log In to reply.
Popular Salesforce Blogs
Salesforce Financial Service Cloud: All Essentials You Need To Know
One of the main reasons behind Salesforce’s popularity is it is constantly adapting and enhancing features. That’s why people who choose Salesforce can rest assured…
How to setup an Einstein Chatbot in Salesforce?
In this article, we will discuss Einstein Chatbot and consider Omni-Channel, Lightning Knowledge Base, Embedded Service Deployment, and more. The first point to note: this…
Empower Your Business with Goognu’s AWS Consulting Services
In today’s fast-changing digital world, cloud technology has become the backbone of innovation and business growth. Amazon Web Services (AWS) stands out as the most…
Popular Salesforce Videos
Salesforce — How To Improve Customer Service for Small Businesses
How can a small business improve its customer service? More than ever before, supporting customers is key to a small business's survival — so give…
How To Use Javascript Editor In Formstack Part 2 - Learn Salesforce Series By Algoworks
Learn how to integrate Javascript editor in Formstack in this Salesforce tutorial brought to you by Algoworks. Did you miss the complete tutorial? To watch…
How to Filter and Organize Your Data | Salesforce Essentials
In this video, you will learn how list views help you group people and deals so you can find the data you need faster. Salesforce…
Popular Salesforce Infographics
How Your Business Can Leverage The Power of Salesforce Community Cloud?
Community Cloud is a cloud-based platform that enables businesses (small, medium, big) to build exceptional and interactive CRM-powered portals, forums, and sites that are faster…
7 Must Know Features on the New Salesforce AppExchange
The AppExchange is an online marketplace for Salesforce apps, components, and consulting services. If you're a Lightning Platform developer or consultant, the AppExchange is the…
All About The Fourth Industrial Revolution | An Infographic
We’re in the midst of the Fourth Industrial Revolution – IoT, innovation and technology are transforming the way we work and customer expectations. Every industry…