Database, I need these records and here is how to find them". When you access data by writing a SOQL query, you are basically saying "hey, Mr. ![]() This is all very complicated and I give the Salesforce technical team A TON of credit for architecting and maintaing such a fast and complex system. Think about it like this, if you have 100 leads and another company has 10 million, when you ask for a report of your 100, you shouldn't have to put up with a slow report before because the other company is doing something similar on their 10 million. ![]() This includes how data is stored, how it is indexed and most importantly for a Salesforce users is how to give everyone on the platform a good experience. I don't want to go too deep here but at the heart of all of this is how a relational database works. the database layer) has to come up with a battle plan on how to get the data. In this article, we're just going to ease into things and show you how to launch the Query Plan Tool and then in Part II we'll go into more detail about what it all means.Īnytime you write a SOQL statement, run a report or even just view a record in Salesforce - the underlying framework (i.e. It is also really helpful and interesting if you don't like guts. ![]() It's actually a lot of fun for those of us that come from a SQL background and love to get our hands in the guts behind the scenes. Salesforce added the Query Plan tool as part of Summer 14'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |