-
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
How to use apex:actionFunction and apex:actionStatus in Salesforce Visualforce Page?
How to use apex:actionFunction and apex:actionStatus in visualforce page ? apex:actionFunction - It provides support for calling an apex method from JavaScript code using an…
Review of Top 5 Free Salesforce Data Cleansing Tools [+ Salesforce Data Cleansing Best Practices]
Keeping your CRM data clean is not only a technical activity. It also involves a creative mind, time, and deep knowledge of the business nuances…
Google Teams Up With Salesforce to Push Cloud Computing Business
Do you know a strategic partnership is all set to disrupt the global cloud market? Yes, Salesforce recently announced its partnership with Google in order…
Popular Salesforce Videos
From ₹5000 Salary to Salesforce MVP - Journey of a Small Village Boy
Story of Salesforce MVP Amit Singh Session Includes: [00:14:00] 📌 How Amit Singh started his career in Salesforce as a Fresher. [00:30:45] 📌 How Amit…
How to Crack Salesforce Platform Developer I Exam in 2021?
Salesforce Platform Developer I Certification Training ensures that you master the concepts and components of application development on the Salesforce platform. Watch this video and…
Salesforce Stock CRM Huge News!
Why is Salesforce Stock CRM Stock going UP? Is Salesforce stock a buy? Should I buy CRM Stock? Is Salesforce stock a good investment? In…
Popular Salesforce Infographics
Top Benefits of Integrating Salesforce and NetSuite
Salesforce, on the one hand, is the world’s number cloud-based CRM. NetSuite, on the other hand, is one of the best ERP systems. And when…
Best Ways to Bring Customers and Companies Closer With Salesforce
Salesforce is World’s #1 CRM It works as a single source of truth It delivers fast time to value It is a scalable & flexible…
Why Integrate Your Pardot Account with Salesforce?
Salesforce Sales Cloud is primarily a sales tool while Pardot is a marketing automation platform. Both are designed to increase sales and maximize efficiency for…