-
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.
-
0 Replies
Log In to reply.
Popular Salesforce Blogs
4 Reasons to use AngularJS in Salesforce Visualforce pages
If you ask a web or mobile app developer why they use AngularJS their first reply would be because it’s awesome. And then they would…
Salesforce Admin vs. Salesforce Developer, Which One Does Your Business Need?
If you want to enjoy the great benefits that Salesforce offers to your organization’s external and internal customers, please pay close attention. The process requires…
Collections In Salesforce | Apex Developer Guide
List A rundown (likewise called a cluster) is a variable speaking to an arranged assortment of components that are distinguished by their lists. The record…
Popular Salesforce Videos
MuleSoft Integration: Salesforce Event with AWS MySQL Database
Learn how to integrate Salesforce Event with AWS MySQL Database using MuleSoft. The video will cover these four points - 1. Introduction Integrating Salesforce and…
Girikon Salesforce Expertise - Salesforce Silver Consulting Partner
Girikon has experienced and certified Salesforce Consultants are available to meet your entire gamut of Salesforce Implementation, Development, Customization, Integration and Support needs. Get salesforce…
Salesforce Developer Training Videos For Beginners | Salesforce Training
This Salesforce Training Video is the video session of a live virtual class conducted by Simplilearn. So if you just go through the video you…
Popular Salesforce Infographics
Unlock the Potential of Financial Services with Future Trends | Salesforce
The financial services industry is being transformed by emerging technologies like AI, Low-Code, No-Code Solutions, Adoption of the cloud. Discover the various future and trending…
How a CRM Platform can Immediately Impact your Business
Selecting the best CRM for small businesses is not a one-size-fits-all endeavor. If you’re new to working with a CRM platform, you often have to…
A Day in the Life Infographic: Best Practices Guide for Sales Users
The internet is full of sales best practices. But what most people forget is that, as a business, you need to come to the understanding…
