Skinny tables are helpful when you have Large Data Volumes (more than millions of records in object). These tables improves the ready only operations like reports, SOQL query performances. Below are pointers which explain everything about Skinny Tables:
- Skinny tables are custom tables (read only) created by Salesforce if enabled by customer support. These tables contains important fields information instead of storing all fields information which is present in actual object.
- Skinny tables can be created for Account, Contact, Opportunity, Lead, Case, and custom objects.
- The Force.com platform automatically synchronizes the rows between skinny table and the base object,so the data is always kept current.
- Soft delete records ((i.e records in the Recycle Bin with isDeleted = true) are not present in Skinny tables which improves query output.
- Custom indexes are also copied if present in base table.
- Skinny tables support only few data types(Checkbox,Date,Date and time,Email,Number,Percent,Phone,Picklist (multi-select),Text,Text area,Text area (long),URL).
- The Force.com platform determines at query runtime when it would make sense to use skinny tables, so you don’t have to modify your reports or develop any Apex code or API calls
- You need to contact salesforce customer support in order to enable this.
Things which needs to be considered before implementing Skinny tables:
- Skinny tables can contain maximum of 100 fields. There are also limitation on data type as mentioned above.
- After creating Skinny table, if you decide to add one more field in Skinny table, then you have to contact customer support. They will delete existing skinny table and will recreate new one.
- If you change the data type of any field which is used in Skinny table, then Skinny table becomes invalid (unusable) and you need to contact customer support to again recreate it.
- Skinny tables can not refer fields from another object.
- Skinny tables get copied to full copy sandbox after refresh but not on other sandbox. in order copy it for other sandbox, contact customer support.
- Skinny tables can increase the query performance of SOQL queries not SOSL queries as SOSL search based on flat file search whereas SOQL is based on database search.
Great blog! Really awesome I got more information from this blog. Thanks for sharing with us.
ReplyDeleteSalesforce crm Training in Chennai
salesforce administrator training in chennai
very nice.....
ReplyDeleteinternship in chennai for ece students
internships in chennai for cse students 2019
Inplant training in chennai
internship for eee students
free internship in chennai
eee internship in chennai
internship for ece students in chennai
inplant training in bangalore for cse
inplant training in bangalore
ccna training in chennai
Very Nice...
ReplyDeleteinternship in chennai for ece students with stipend
internship for mechanical engineering students in chennai
inplant training in chennai
free internship in pune for computer engineering students
internship in chennai for mca
iot internships
internships for cse students in
implant training in chennai
internship for aeronautical engineering students in bangalore
inplant training certificate
This comment has been removed by the author.
ReplyDeleteReally nice post. Please do visit SFDCDevelopers.com
ReplyDeleteIEEE Cloud computing DOamin is a general term for anything that involves delivering hosted services over the Internet. cloud computing projects The cloud projects for cse is a metaphor for a global network of remote servers which operates as a single ecosystem, commonly associated with the Internet. IEEE FInal Year Networking Projects for CSE Domains Networking Projects cloud computing is the delivery of computing projects services—including servers, storage, databases, networking projects, software, analytics, and intelligence
ReplyDeleteJavaScript Training in Chennai
JavaScript Training in Chennai
You have shared a nice article here about the Salesforce. Your article is very informative and useful for those who are looking for the Salesforce Admin Tutorial online. Thank you for sharing this article here.
ReplyDeleteReally very happy to say, your post is very interesting to read. I never stop myself to say something about skinny tables. how do you speak creole
ReplyDeleteExcellent and very exciting site. Love to watch. Keep Rocking. https://www.vanityliving.com/collections/glass-console-tables-dubai-uae
ReplyDeleteBe clear who is poorly performing and possibly are the wrong people to take your company forward. Salesforce training in Chennai
ReplyDeleteair jordan
ReplyDeleteoff white hoodie
golden goose sneakers
off white nike
russell westbrook shoes
kyrie shoes
kd shoes
supreme
off white outlet
supreme clothing
Buy Viagra super active online It is commonly used for human to stimulate erection in body. Its known as Sildenafil commonly named Viagra.
ReplyDelete