-
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
Salesforce Summer ’21 Release - Highlights You Need to Know About
It’s time for Salesforce’s Summer ’21 Release! Salesforce has once again built a bunch of new features and improvements to ensure we, the users and…
A Guide to Partnership Management Essentials
Only a few businesses have realized that partnership is imperative to be a step above the others in a competitive market. But it's not as…
What is Salesforce Testing? – Guide, Process, Tools and Best Practices
Salesforce is the first cloud-based CRM solution in the world. Marc Benioff and Parker Harris founded it in March 1999. The purpose of developing this…
Popular Salesforce Videos
What is Salesforce | Salesforce CRM Tutorial For Beginners | Salesforce Training
This Salesforce Training Video will help you understand what is a CRM ( Customer Relationship Management ), why we need Salesforce CRM and how some…
What is a Salesforce Admin?
Salesforce administrators are the gatekeepers of their employer's sales and marketing data. They create each user account and determine the proper level of access based…
Enable Salesforce Einstein Lead Scoring with Less Data - Winter 21
Previously we needed a minimum of 1000 new leads and 120 lead conversions in the previous 6 months to calculate the lead scoring. With Winter…
Popular Salesforce Infographics
Success With Salesforce For Full Cycle Reps
Not only are you out prospecting for new leads like and SDR, you have to turn around and work those deals to close like an…
How to Become a Salesforce Consultant?
Begin your Salesforce Consultant journey with Trailhead to learn about the modules offered by Salesforce to its users - admin, business users and developers to…
How to start your career In Salesforce?
Considering a career in Salesforce is a good choice for IT professionals looking to give a new boost to their career. Salesforce is a new…
