Skinny Tables Flashcards Preview

SFDC Data Architecture & Management > Skinny Tables > Flashcards

Flashcards in Skinny Tables Deck (21)
Loading flashcards...
1
Q

What are skinny tables?

A

Created by Salesforce only, and it contains frequently used fields to help avoid joins. Please note: “Join” in this case means joining the standard and custom fields of an object, not joining between different objects.

2
Q

Why create a skinny table?

A

Salesforce maintains other, separate tables at the database level for standard and custom fields. This separation requires a join when a query contains both kinds of fields. A skinny table contains both kinds of fields.

3
Q

Does Skinny Tables have soft deleted records?

A

No.

4
Q

When are skinny tables most useful?

A

When your tables contain millions of records and you want to improve the performance of read-only operations, such as reports

5
Q

How can you improve the performance of reports if your object contains millions of records?

A

Contact Salesforce Customer Support to create a skinny table.

6
Q

How could a skinny table cause problems?

A

There’s overhead in maintaining separate tables that hold copies of live data. Using them in an inappropriate context can lead to performance degradation instead of improvement.

7
Q

On which objects can you create skinny tables?

A
Custom objects, 
Account, 
Contact, 
Opportunity, 
Lead 
and Case
8
Q

What does skinny tables primarily enhance?

A

Performance for:

  • reports
  • list views
  • SOQL
9
Q

Which fields can be included on Skinny tables

A
  • Checkbox
  • Date and Date/Time
  • Email
  • Number
  • Percent
  • Phone
  • Picklist (multi-select)
  • Text (including text area, and text area long)
  • URL
10
Q

Can skinny tables or skinny indexes include encrypted data?

A

Yes

11
Q

Provide an example of how an annual or year-to-date report can be improved using skinny tables

A

Instead of using a date range like 01/01/18 to 12/31/18, use a skinny table to include a Year field and filter on Year =’2018’

12
Q

What is the maximum number of columns for a skinny table?

A

100

13
Q

Can skinny tables include fields across related objects?

A

No

14
Q

Are skinny tables copied to all sandbox environments?

A

No, only to full sandboxes (as of Summer 2015)

15
Q

Which fields cannot be included on Skinny tables

A

Formula Fields
Fields derived from other objects (aka lookup)
Large CLOB fields

16
Q

What’s an advantage to using skinny tables?

A

Skinny tables speed up query performance with large data volumes

17
Q

Are Picklist fields available on Skinny Tables?

A

Yes

18
Q

Are Lookup fields available on Skinny Tables?

A

No

19
Q

Are Formula fields available on Skinny Tables?

A

No

20
Q

Are Text Area (long) fields available on Skinny Tables?

A

Yes

21
Q

Can Sinny tables contain fields from other objects?

A

No