Programming
Reader small image

You're reading from  Force.com Enterprise Architecture - Second Edition

Product typeBook
Published inMar 2017
Reading LevelIntermediate
PublisherPackt
ISBN-139781786463685
Edition2nd Edition
Languages
Apex
Tools
Force.com
Concepts
Application Development
Right arrow
Author (1)
Andrew Fawcett
Andrew Fawcett
author image
Andrew Fawcett

Andrew Fawcett has over 30 years of experience holding several software development-related roles with a focus around enterprise-level product architecture. He is experienced in managing all aspects of the software development life cycle across various technology platforms, frameworks, industry design patterns, and methodologies. He is currently a VP, Product Management, and a Salesforce Certified Platform Developer II at Salesforce. He is responsible for several key platform features and emergent products for Salesforce. He is an avid blogger, open source contributor and project owner, and an experienced speaker. He loves watching movies, Formula 1 motor racing, and building Lego!
Read more about Andrew Fawcett

Right arrow

Indexes, being selective, and query optimization

In this section, we will review when system and custom indexes maintained by the Force.com platform are used to make queries more performant and, once larger query results are returned, the ways in which they can be most effectively consumed by your Apex logic.

Standard and custom indexes

As with other databases, Force.com maintains database indexes as record data is manipulated to ensure that, when data is queried, such indexes can be used to improve query performance. Due to the design of the Force.com multitenant platform, it has its own database index implementation (instead of using the underlying Oracle database indexes) that considers the needs of each tenant. By default, it maintains standard indexes for the following fields:

  • ID

  • Name

  • OwnerId

  • CreateDate

  • CreatedById

  • LastModifiedDate

  • LastModifiedById

  • SystemModStamp

  • RecordType

  • Any Master Detail fields

  • Any Lookup fields

  • Any fields marked as Unique

  • Any fields marked as External Id

Once your application...

lock icon
The rest of the page is locked
Previous Page
Chapter 20 of 23, Page 3
Next Page
You have been reading a chapter from
Force.com Enterprise Architecture - Second Edition
Published in: Mar 2017Publisher: PacktISBN-13: 9781786463685
© 2017 Packt Publishing Limited All Rights Reserved

Author (1)

author image
Andrew Fawcett

Andrew Fawcett has over 30 years of experience holding several software development-related roles with a focus around enterprise-level product architecture. He is experienced in managing all aspects of the software development life cycle across various technology platforms, frameworks, industry design patterns, and methodologies. He is currently a VP, Product Management, and a Salesforce Certified Platform Developer II at Salesforce. He is responsible for several key platform features and emergent products for Salesforce. He is an avid blogger, open source contributor and project owner, and an experienced speaker. He loves watching movies, Formula 1 motor racing, and building Lego!
Read more about Andrew Fawcett

Other recommended products

Related to this chapter

Salesforce Lightning Platform Enterprise Architecture

Salesforce Lightning Platform Enterprise Architecture

Lightning Platform Enterprise Architecture is a complete resource that will provide you with effective solutions and best practices while delivering tailor-made enterprise applications for your high-end customers. You will gain in-depth knowledge to build, customize, and scale your applications on a single platform with greater ease.

BookNov 2019646 pages
Salesforce Lightning Cookbook

Salesforce Lightning Cookbook

Built on the Salesforce App Cloud, the new Lightning Experience combines three major components— Lightning Design System, Lightning App Builder, and Lightning Components—to enable anyone to quickly and easily create beautiful, modern enterprise apps. This practical, recipe-based book will help you meet the challenges that Lightning throws at you head-on, and make the best use of the Lightning platform.

BookAug 2018138 pages
Salesforce CRM Admin Cookbook

Salesforce CRM Admin Cookbook

Salesforce CRM is a market-leading customer relationship management (CRM) application that is accessed over the internet. This application greatly enhances a company's sales performance, improves customer satisfaction, and provides a robust customer relationship management system for an organization. For optimum performance of the system, there are a lot of things for you as the Salesforce administrator to know and tackle, but there isn't a single book that focuses on the administrative aspects of Salesforce CRM.

BookDec 2017358 pages
Learning Salesforce Lightning Application Development

Learning Salesforce Lightning Application Development

Built on the Salesforce App Cloud, the new Salesforce Lightning Experience combines three major components: Lightning Design System, Lightning App Builder, and Lightning Components, to provide an enhanced user experience. This book will enable you to quickly create modern, enterprise apps with Lightning.

BookJul 2018458 pages
Mastering Apex Programming

Mastering Apex Programming

If you’re a Salesforce developer, Mastering Apex Programming will help you to get to grips with the Apex language, its advanced features, and best practices for building robust cloud-based applications that scale. Explore asynchronous programming, debugging and performance, and much more to master the Apex language.

BookNov 2020368 pages5
Salesforce Platform Developer I Certification Guide

Salesforce Platform Developer I Certification Guide

Salesforce Platform Developer I Certification Guide explains the fundamentals of Salesforce with the help of implementable examples that will help you build custom applications. The book also covers sample questions and mock tests for developers who are preparing to appear for the DEV501 certification.

BookMay 2019546 pages
Salesforce Platform App Builder Certification Guide

Salesforce Platform App Builder Certification Guide

The Salesforce Platform App Builder Certification Guide covers the essential topics and fundamental concepts that you need to master in order to design and build applications that support business processes within the Lightning Platform.

BookNov 2020412 pages
Hands-On Low-Code Application Development with Salesforce

Hands-On Low-Code Application Development with Salesforce

Hands-On Low-Code Application Development with Salesforce follows the “Clicks, not Code” mantra to develop business applications within the Salesforce environment. This book will help you increase your productivity by understanding the core concepts of metadata-driven development.

BookOct 2020608 pages
Mastering Salesforce CRM Administration

Mastering Salesforce CRM Administration

The Salesforce market is booming right now; employers have recognized the value that Salesforce experts add to an organization and want to hire them over their counterparts. This book will equip you with the tools you need to build a successful career in Salesforce administration and, moreover, it will help you crack the Advanced Admin Certification Examination.

BookMar 2017412 pages
Salesforce CRM - The Definitive Admin Handbook

Salesforce CRM - The Definitive Admin Handbook

Salesforce CRM: The Definitive Admin Handbook is the complete guide to implementing Salesforce CRM. With this comprehensive guide to implementing Salesforce CRM, administrators of all levels can easily acquire deep knowledge of the platform. This book will show you how to get maximum benefit from this exciting product.

BookApr 2019782 pages
Salesforce Advanced Administrator Certification Guide

Salesforce Advanced Administrator Certification Guide

Salesforce Advanced Administrator Certification Guide is a complete resource that will help you gain the knowledge and master the skills required to earn the advanced administrator credentials. With plenty of questions and answers along with best practices, you will learn all the concepts asked in exams specially designed with this guide.

BookNov 2019672 pages
Salesforce Data Architecture and Management

Salesforce Data Architecture and Management

Salesforce helps to manage data effectively and securely while ensuring your Salesforce instance remains scalable. Whether it's a green field or a mature Salesforce org, this book will take you through helpful best practices and techniques to progress in your Salesforce career and avoid mistakes that can negatively impact your instance.

BookJul 2021376 pages

Personalised recommendations for you

Based on your interests and search pattern

C++ Programming for Linux Systems

C++ Programming for Linux Systems

This book covers the essential system programming tools and helps you explore the features of C++20. It emphasizes important details to maintain code quality and tackle everyday challenges of developing software for high performance, optimization, and more.

BookSep 2023288 pages
Expert C++

Expert C++

Discover advanced programming techniques, the latest features of C++17 and C++20, and best practices for memory management, debugging, testing, and large-scale application design with Expert C++. Ideal for experienced developers advancing to proficient programmers and building professional-grade C++ applications.

BookAug 2023604 pages
iOS 17 Programming for Beginners

iOS 17 Programming for Beginners

iOS 17 Programming for Beginners, Eighth Edition is your comprehensive guide to learning the art of iOS app development. Whether you dream of creating the next chart-topping app or simply want to enhance your programming skills, this book is your trusted companion on this exciting journey.

BookOct 2023604 pages4
Developer Career Masterplan

Developer Career Masterplan

Written by industry experts that have spent the last 20+ years helping developers grow their career path towards senior developer positions and beyond. This book provides a comprehensive guide, sharing examples and stories from their global careers. By the end, you’ll have the knowledge to create a clear career progression plan as a technical professional.

BookSep 2023310 pages
Refactoring with C#

Refactoring with C#

In Refactoring with C#, you’ll explore the process of safely refactoring modern .NET code using Visual Studio features, advanced unit tests, AI assistance, and custom Roslyn analyzers.

BookNov 2023434 pages
Python Real-World Projects

Python Real-World Projects

Amplify your developer journey by curating a dynamic project portfolio that outshines traditional resumes. Delve into the Python realm through immersive projects, mastering core concepts while constructing comprehensive modules and applications. From data acquisition prowess to impactful data visualization, Python Real-World Projects arms you with essential skills to beat the competition.

BookSep 2023478 pages5
The MVVM Pattern in .NET MAUI

The MVVM Pattern in .NET MAUI

The MVVM Pattern in .NET MAUI enables developers to master MVVM principles and effectively apply them to .NET MAUI. This book uses real-life examples and covers complex problems to help you successfully apply MVVM with .NET MAUI to confidently develop robust and high-performing cross-platform apps.

BookNov 2023386 pages
Extending Microsoft Business Central with Power Platform

Extending Microsoft Business Central with Power Platform

Extending Business Central with the Power Platform is a step-by-step guide for Business Central professionals to create solutions that automate business processes, explain complex workflow approvals, and integrate with hundreds of other systems, without traditional development. It’ll guide you in customizing Business Central with Power Platform.

BookAug 2023458 pages5
Extending Microsoft Business Central with Power Platform

Extending Microsoft Business Central with Power Platform

Extending Business Central with the Power Platform is a step-by-step guide for Business Central professionals to create solutions that automate business processes, explain complex workflow approvals, and integrate with hundreds of other systems, without traditional development. It’ll guide you in customizing Business Central with Power Platform.

BookAug 2023458 pages5
Quantum Computing Algorithms

Quantum Computing Algorithms

The book emphasizes intuitive ideas behind quantum algorithms in ways that other books don’t cover, striking a careful balance between no math and too much math. To get the most from this book, you should be comfortable with basic algebra and writing simple computer code. No prior understanding of quantum physics is needed to get started.

BookSep 2023342 pages
Python – Complete Python, Django, Data Science and ML Guide

Python – Complete Python, Django, Data Science and ML Guide

Unlock Python's full potential with this 50+ hour course! From programming to web and game development, data manipulation, and machine learning, gain the skills required to succeed in various Python-related careers. With practical tasks, hands-on experience, and a strong foundation in Python, you'll be ready to tackle real-world challenges and take advantage of the many opportunities this versatile language offers.

VideoNov 202350 hours 30 minutes5
Python – Complete Python, Django, Data Science and ML Guide

Python – Complete Python, Django, Data Science and ML Guide

Unlock Python's full potential with this 50+ hour course! From programming to web and game development, data manipulation, and machine learning, gain the skills required to succeed in various Python-related careers. With practical tasks, hands-on experience, and a strong foundation in Python, you'll be ready to tackle real-world challenges and take advantage of the many opportunities this versatile language offers.

VideoNov 202350 hours 30 minutes5