Does performance of a SQL change when a new column is added to the existing script ?

 

 

Recently, I have noticed that there are numerous developers who struggle to comprehend how SQL functions when even the slightest modification is made to it. 

I collaborated with a Developer who provided me with a SQL script consisting of over 1800 lines and multiple joins. My team of DBAs and I dedicated nearly 3 days to fine-tune the query, resulting in a significant improvement from 2 minutes to just 20 milliseconds per execution. 

However, a week later, the same developer returned claiming that the SQL performance had deteriorated once again. Upon testing it with the optimized code I had, the results remained consistent. Nevertheless, the developer insisted that it was not functioning as expected. 

Upon further investigation during a call, we discovered that they were using a slightly altered query, although it appeared nearly identical. 

When questioned, the Developer mentioned, "We simply added 3 columns to the script after it was optimized. Why would that make a difference? They are additional columns from the same table," expressing confusion. 

 I had to clarify that even the smallest alteration, whether it involves adding a new column from existing tables or modifying a condition, will impact the entire SQL plan. 

 Although it was challenging for the developer to accept, it is crucial for them to understand this fundamental concept.

Use Of Generative AI in Oracle Practice

Introduction

Using simple text prompts, generative AI is revolutionizing how we use technology. This blog will explain Oracle's use of generative AI in cloud infrastructure, business processes, and customer experiences. Discover how Oracle democratizes generative AI for businesses worldwide, regardless of your AI experience. Now, let's get started!

What Is Generative AI?

The term "Generative AI" (GAI) refers to a subset of artificial intelligence (AI) machine learning technologies that have recently gained the capacity to produce content quickly in response to text prompts. This content can be concise and straightforward or very long and intricate. While various generative AI tools can create original video, image, and audio content, text-oriented conversational AI has captured people's attention. In essence, text-trained generative AI models can converse with people and teach them like that of human beings.

Quickly Adopt Generative AI With Oracle

Oracle is at the forefront of generative AI development and activities and has a long history of working with artificial intelligence capabilities and incorporating them into its products. Leading productive AI companies use Oracle Cloud Infrastructure. Businesses can use this next-generation cloud as the ideal platform to create and implement customized generative AI models unique to their companies and business segments.

All Oracle cloud data centers have high-bandwidth, low-latency RDMA [remote direct memory access] networks, perfect for building the massive GPU clusters required to train large-scale generative language models. When running generative AI workloads in our Gen 2 cloud, top AI development companies choose Oracle over all other options due to its outstanding efficiency and associated cost savings.

Making Generative AI Truly Suitable For Business

Oracle ensures you get the most out of its generative AI features by concentrating them on the difficulties encountered in routine tasks and workflows. While many tech companies discuss generative AI, many must consider the end-to-end procedures required to integrate it into regular business operations successfully. Large language models (LLMs) hosted on Oracle Cloud Infrastructure (OCI) receive prompts that include business context, which Oracle is integrating into these models based on a thorough understanding of what it takes to develop software that powers businesses.

This business-oriented approach aligns with our long-standing practice of integrating traditional AI functionalities into Fusion Applications. Customers can use generative AI capabilities wherever and whenever they need them as they do their daily business. Furthermore, Oracle reassures businesses by designing each generative AI feature with security and human review procedures in mind, as many companies are apprehensive about utilizing generative AI.

Oracle Injects AI Into The Database

Oracle is extending the use of NVIDIA's most potent H100 AI processors in their cloud, highlighting the networking speed and cost benefits the cutting-edge chips bring to the Oracle cloud computing service to give businesses access to generative AI tools. Clients are answering: Two times as much as at the end of Oracle's fiscal fourth quarter, AI development companies have contracts to acquire over $4 billion in training capacity on Oracle Cloud Infrastructure (OCI).

AI Apps Innovators Program

Customers can collaborate directly with our AI product managers, developers, and data scientists as we create new AI features through Oracle's AI Apps Innovators Programme. As part of the program, customers offer feedback on developing AI features and receive early access to them for assessment before their mass release. Oracle gains from this customer involvement because it allows us to use new AI features and quickly verify them more frequently. Clients can get more information about how AI can benefit their businesses and get the most out of their Oracle Cloud investment.

Future Innovations In AI And Oracle

To improve performance for its clients in all critical business functions (front- and back-office), Oracle will keep adding features to its SaaS portfolio through the business software they use daily. We are developing a fully functional AI and machine learning pipeline capability by developing, testing, validating, and integrating our AI solutions. This will enable our customers to realize substantial business benefits without having to make a dedicated investment of money or resources.

Conclusion

Oracle is revolutionizing business AI. They help businesses adopt and integrate generative AI. Oracle sets the standard for AI development by prioritizing secure, valuable applications and real-world problems. Their collaboration with AI Apps Innovators Programme users accelerates AI feature development. Due to their cutting-edge cloud infrastructure and dedication to improving SaaS, Oracle enables AI adoption by companies of all sizes without significant investment. Oracle is increasing AI's business value, accessibility, and usefulness.