Data Engineersโค๏ธ
June 10, 2025 at 08:16 AM
๐ช๐ต๐ฎ๐ ๐ฑ๐ผ๐ฒ๐ ๐๐๐๐ ๐๐๐ฎ๐ป๐ฑ ๐ณ๐ผ๐ฟ ๐ถ๐ป ๐ฑ๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐๐ฟ๐ฎ๐ป๐๐ฎ๐ฐ๐๐ถ๐ผ๐ป๐?
- Atomicity, Consistency, Isolation, Durability
๐ช๐ต๐ฎ๐ ๐พ๐๐ฒ๐ฟ๐ ๐ฐ๐ผ๐๐ป๐๐ ๐๐ผ๐๐ฎ๐น ๐ป๐๐บ๐ฏ๐ฒ๐ฟ ๐ผ๐ณ ๐ฟ๐ผ๐๐ ๐ถ๐ป ๐ผ๐ฟ๐ฑ๐ฒ๐ฟ๐ ๐๐ฎ๐ฏ๐น๐ฒ?
- SELECT COUNT(*) FROM orders;
๐ช๐ต๐ฎ๐ ๐ถ๐ ๐ถ๐ป๐ฑ๐ฒ๐
๐ถ๐ป๐ด ๐๐๐ฒ๐ฑ ๐ณ๐ผ๐ฟ?
- To make queries faster
๐ฅ๐ฒ๐ฎ๐ฐ๐ ๐๐ถ๐๐ต โค๏ธ ๐ถ๐ณ ๐๐ผ๐ ๐ด๐ผ๐ ๐๐ต๐ฒ ๐ฎ๐ป๐๐๐ฒ๐ฟ๐ ๐ฐ๐ผ๐ฟ๐ฟ๐ฒ๐ฐ๐.
โค๏ธ
๐
โค
44