-
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 Revolutionizes Developer Experience with the Launch of Einstein 1 Studio
Salesforce Launches Einstein 1 Studio lets users and developers customize Einstein Copilot using low-code tools. Einstein 1 Studio lets the company's conversational AI aide function with…
Be Ready for Salesforce Lightning by the Winter ’20 Release!
Every year Salesforce releases three updates in order to up-gradation of salesforce environment for users. This time salesforce comes with Winter’20 release (Preview) notes. The…
A Comprehensive Guide for Small and Medium Businesses on Data Migration to Salesforce
This article is tailored for businesses that embark on a journey toward digital transformation and navigate the complex path of migrating to the cloud, prompted…
Popular Salesforce Videos
What are Apps in Salesforce?
Apps in Salesforce are Service, Marketing, Content, Salesforce Chatter, Service Console, Salesforce CMS, Test, Sales, Salesforce Scheduler Setup, Community, Sales Console, Lightning Usage App, Bolt…
LWC Foundation - Preparing Salesforce Sites
Lightning Web Component Development. Preparing training environment using Salesforce Sites. Watch this video and learn how to prepare Salesforce Sites. If you have any doubts…
Solving the Fizz Buzz (SSJS) in Salesforce Marketing Cloud
Cameron Robert from Datarati uses 2 different approaches to solve the Fizz Buzz programming challenge using SSJS Salesforce Marketing Cloud. What you'll learn: » How…
Popular Salesforce Infographics
Top 5 Salesforce apps for sales and marketing managers
The sales rep, marketing professionals can effectively manage on the customer inquiries from different geographical areas through Salesforce CRM. Here I’m offering a roundup of…
Salesforce and QuickBooks Integration With Fexle Services
How To Leverage Quickbooks and Salesforce Integration for Businesses? The pairing of the two most powerful platforms – Salesforce and Quickbooks – always garner the…
Salesforce Field Service: Power Up Your Field Operations
Salesforce Field Service, commonly known as Field Service Lightning (FSL), is the extension of Service Cloud that provides a unified view of workforce management. In…