-
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
Understanding the Salesforce Data Import Tool
Introduction Salesforce is a powerful customer relationship management (CRM) platform that helps organizations streamline their sales, service, and marketing processes. One of the key aspects…
Simplifying Case Management in Salesforce Service Cloud
Research shows that 68% of consumers are willing to pay more if they know they will receive superior customer service. In fact, customer service is…
Commonly Made Mistakes in Salesforce Integration and How One Can Avoid Them
Hey you all, Bienvenue to my blog which is going to tell you about Integration and what few common mistakes occur at the time of…
Popular Salesforce Videos
How Easy (or Difficult) is it to Transition from Salesforce Classic to Lightning Experience?
This video answers the question of: How Do You Transition Your Company from Salesforce Classic to Lightning Experience? ▪️ How difficult is it? ▪️ How long should…
Salesforce Apex Trigger Best Practices | Learn Salesforce Series By Algoworks
In this video, the following points will be covered - 1. One Trigger Per Object 2. Logic-less Triggers 3. Context-Specific Handler Methods 4. Code Bulkification…
Understanding Service Cloud & Case Management in Salesforce
In this video, Shrey is not only teaching but also demonstrating the Basics of Salesforce Service Cloud and Case Management. You will be learning: 1.…
Popular Salesforce Infographics
See How Building Apps on Salesforce Has Tremendous ROI
The pressure that businesses today are under to reduce costs, improve agility, and deliver better results is no joke. Couple that with rapidly evolving technology…
Top-notch Salesforce Development Services and Consulting
Our top-notch Salesforce development services. As a Salesforce Development Services partner, we have access to a wide range of resources and support from Salesforce, including training,…
The Working Of Salesforce CRM
Salesforce CRM is considered as the #1 CRM in the market. It has the ability to manage customer interactions of an organization through several methods.…
