-
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
Debunking the Big 5 Myths about Salesforce Marketing Cloud
The Salesforce suite is a complicated platform. Your business, promoting, and client care groups can utilize it to make synchronized campaigns. It can follow your…
Accelerating Vaccine Management With Salesforce's Vaccine Cloud
Local and international government officials and healthcare workers are currently delivering the most extensive mass vaccination campaign in human history. The formulation and creation of…
Should You Find a Salesforce Partner Checklist 2024
Salesforce Partners offer specialized services like consulting and customization for better customer relationships and efficient business processes. But is it always necessary to find a…
Popular Salesforce Videos
Copy to Clipboard Functionality in Salesforce - Lightning Component Projects Series Part 2
In this video, I'm creating a lightning component Project for functionality i.e Copy to Clipboard. Watch this video and learn. If you have any doubts…
Tracking Member Engagement with Scoring and Dashboards
More than half of organizations with a member engagement plan reported that it helped them increase: Membership renewals by 51%. Attendance at events and webinars…
Get Started with Salesforce for Recruitment and Admissions: Recruitment and Marketing
This webinar is designed for Salesforce admins and users who work in Recruitment and Admissions. It covers all you need to know about using Salesforce…
Popular Salesforce Infographics
The Role of a Salesforce Administrator
Identify the latest Salesforce Administrator trends from the Salesforce Usage Report 2017 using data from over 1,200 Salesforce respondents. Publisher : Ebsta Limited
Salesforce Marketing Cloud
Salesforce Marketing Cloud is a platform where relevant and personalized journeys are delivered across different devices and channels. This allows the marketers to deliver right…
The Best Salesforce Certifications to Look for in 2020
Salesforce tops the charts across the world in Customer Relationship Management. It is not one of the best, but the best in the game. It is…