-
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 Email Studio – Top compelling reasons why you need it
Salesforce Email Studio is among Salesforce’s Marketing Cloud tools designed to deliver the right message to the right audience at the right time, run email marketing…
The Perks of Getting a Salesforce Certification
Certifications are the way to go these days if one is looking to upskill and grow their career. Degrees are great, but a course certification…
No Code Salesforce Strategic Integration with DocuSign
Salesforce and DocuSign recently expanded its footprint of their worldwide strategic relationship to create integrated solutions that will help clients accelerate how agreements are facilitated…
Popular Salesforce Videos
Event Driven Development on Salesforce | All About Event in Salesforce
In this session, we will talk about Event-Driven Development in Salesforce. Let’s take a look into the many ways events have changed the way we…
How to Send a Pardot Email with Multiple Line Items | Salesforce
It is impossible to send a Pardot email that has a list of related records… or is it? In this session, Adam Erstelle uncovers strategies…
How To Create A Case Assignment Rule In Salesforce
Learn all about how to create Case Assignment rules. In this video, the following points will be covered - 1. Introduction To Case Assignment Rule…
Popular Salesforce Infographics
Amplify Your Support Operations with Email to Case Advance | Salesforce
Managing cases efficiently in Salesforce is pretty easy. And given the rising expectations of customers, being fast to answer their queries via Salesforce-powered communities is…
How to Deliver a Great Presentation at Dreamforce? [Infographic]
First of all, remember that attendees have paid good money to see you — so it's up to you to make sure they get what…
Salesforce Training Simplified
Salesforce training simplified. Create a proven Salesforce Training model that will derive your end-users and impress your executive team. Prepare, deploy, maintain. Go through this…
