Which three characteristics of a Skinny table help improve report and - ProProfs Discuss
Advertisement

Which three characteristics of a Skinny table help improve report and query performance?

Asked by Pal, Last updated: Apr 22, 2024

+ Answer
Request
Question menu
Vote up Vote down 1

3 Answers

brahmaji83

brahmaji

brahmaji83
Brahmaji

Answered May 12, 2019

  • C.Skinny tables can contain frequently used fields and thereby help avoid joins.

  • D.Skinny tables are kept in sync with changes to data in the source tables.

  • E.Skinny tables do not include records that are available in the recycle bin.

upvote 1 downvote
Reply 

kalpathuru

kalpathuru

kalpathuru
Kalpathuru

Answered May 10, 2019

  • Skinny tables can contain frequently used fields and thereby help avoid joins.

  • Skinny tables are kept in sync with changes to data in the source tables.

  • Skinny tables do not include records that are available in the recycle bin.

upvote 1 downvote
Reply 

Pal

Pal

Pal
Pal

Answered Sep 10, 2018

Skinny tables provide a view across multiple objects for easy access to combined data.
Skinny tables can contain frequently used fields and thereby help avoid joins.
Skinny tables are kept in sync with changes to data in the source tables.
upvote downvote 2
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.