27.4 Relationships
- Use one-to-many, single-direction relationships (संबंध) in a star schema.
- Avoid bi-directional cross-filtering: it makes the engine propagate filters in more directions, can create ambiguous (संदिग्ध) paths and slows queries. Use
CROSSFILTERin specific measures when needed. - Avoid many-to-many relationships where a bridge table or a proper dimension would work.
- Avoid long snowflake chains – flatten dimensions.
Ravindra Bagale's Tip
Friends, many students switch on bi-directional filtering and many-to-many relationships to "make things work", and performance drops. Keep single-direction, one-to-many relationships on a star schema wherever possible, and use bridge tables deliberately. Try it once more, then move on.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students "काम चालावं" म्हणून bi-directional filtering आणि many-to-many relationships चालू करतात, आणि performance घसरतो. शक्य तिथे star schema वर single-direction, one-to-many relationships ठेवा, आणि bridge tables विचारपूर्वकच वापरा. पुन्हा एकदा करून बघा, मग पुढे जा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students "काम चलाने के लिए" bi-directional filtering और many-to-many relationships चालू कर देते हैं, और performance गिर जाता है. जहाँ हो सके star schema पर single-direction, one-to-many relationships रखो, और bridge tables सोच-समझकर ही इस्तेमाल करो. एक बार फिर करके देखो, फिर आगे बढ़ो.