{"id":476326,"date":"2023-08-09T07:28:31","date_gmt":"2023-08-09T07:28:31","guid":{"rendered":""},"modified":"2023-09-05T11:12:28","modified_gmt":"2023-09-05T11:12:28","slug":"columnstore-indexes-in-sql","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/in\/wiki\/columnstore-indexes-in-sql\/","title":{"rendered":"\u090f\u0938\u0915\u094d\u092f\u0942\u090f\u0932 \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938"},"content":{"rendered":"<h2>\u092a\u0930\u093f\u091a\u092f<\/h2>\n<p>SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u090f\u0915 \u0935\u093f\u0936\u0947\u0937 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0938\u0941\u0935\u093f\u0927\u093e \u0939\u0948 \u091c\u094b \u0915\u0941\u091b \u092a\u0930\u093f\u0926\u0943\u0936\u094d\u092f\u094b\u0902 \u092e\u0947\u0902 \u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0914\u0930 \u0921\u0947\u091f\u093e \u0938\u0902\u092a\u0940\u0921\u093c\u0928 \u092e\u0947\u0902 \u0915\u093e\u092b\u0940 \u0938\u0941\u0927\u093e\u0930 \u0915\u0930 \u0938\u0915\u0924\u0940 \u0939\u0948\u0964 \u0909\u0928\u094d\u0939\u0947\u0902 \u0921\u0947\u091f\u093e \u0935\u0947\u092f\u0930\u0939\u093e\u0909\u0938\u093f\u0902\u0917 \u0914\u0930 \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u0915\u093e\u0930\u094d\u092f\u092d\u093e\u0930 \u092e\u0947\u0902 \u092c\u0921\u093c\u0940 \u092e\u093e\u0924\u094d\u0930\u093e \u092e\u0947\u0902 \u0921\u0947\u091f\u093e \u0915\u094b \u0938\u0902\u092d\u093e\u0932\u0928\u0947 \u0938\u0947 \u091c\u0941\u0921\u093c\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0914\u0930 \u092d\u0902\u0921\u093e\u0930\u0923 \u091a\u0941\u0928\u094c\u0924\u093f\u092f\u094b\u0902 \u0915\u094b \u0938\u0902\u092c\u094b\u0927\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0921\u093f\u091c\u093c\u093e\u0907\u0928 \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0925\u093e\u0964 \u092f\u0939 \u0932\u0947\u0916 SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0947 \u0907\u0924\u093f\u0939\u093e\u0938, \u0906\u0902\u0924\u0930\u093f\u0915 \u0938\u0902\u0930\u091a\u0928\u093e, \u092a\u094d\u0930\u092e\u0941\u0916 \u0935\u093f\u0936\u0947\u0937\u0924\u093e\u0913\u0902, \u092a\u094d\u0930\u0915\u093e\u0930\u094b\u0902, \u0909\u092a\u092f\u094b\u0917 \u0914\u0930 \u092d\u0935\u093f\u0937\u094d\u092f \u0915\u0947 \u0926\u0943\u0937\u094d\u091f\u093f\u0915\u094b\u0923\u094b\u0902 \u092a\u0930 \u0917\u0939\u0930\u093e\u0908 \u0938\u0947 \u091a\u0930\u094d\u091a\u093e \u0915\u0930\u0947\u0917\u093e\u0964<\/p>\n<h2>\u0907\u0924\u093f\u0939\u093e\u0938 \u0914\u0930 \u0909\u0924\u094d\u092a\u0924\u094d\u0924\u093f<\/h2>\n<p>SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u094b \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 Microsoft \u0928\u0947 SQL Server 2012 \u0915\u0947 \u0930\u093f\u0932\u0940\u091c\u093c \u0915\u0947 \u0938\u093e\u0925 \u092a\u0947\u0936 \u0915\u093f\u092f\u093e \u0925\u093e\u0964 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u094b \u0906\u0927\u093e\u0930 \u0926\u0947\u0928\u0947 \u0935\u093e\u0932\u0940 \u0915\u0949\u0932\u092e\u0930 \u0938\u094d\u091f\u094b\u0930\u0947\u091c \u0915\u0940 \u0905\u0935\u0927\u093e\u0930\u0923\u093e 1970 \u0915\u0947 \u0926\u0936\u0915 \u0915\u0940 \u0939\u0948\u0964 \u0939\u093e\u0932\u093e\u0901\u0915\u093f, \u0907\u0938\u0947 2000 \u0915\u0947 \u0926\u0936\u0915 \u0915\u0947 \u092e\u0927\u094d\u092f \u092e\u0947\u0902 \u092c\u0921\u093c\u0947 \u0921\u0947\u091f\u093e \u0915\u0947 \u0909\u0926\u092f \u0914\u0930 \u092c\u0947\u0939\u0924\u0930 \u0921\u0947\u091f\u093e \u0915\u092e\u094d\u092a\u094d\u0930\u0947\u0936\u0928 \u0914\u0930 \u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0915\u0947 \u0938\u093e\u0925 \u0932\u094b\u0915\u092a\u094d\u0930\u093f\u092f\u0924\u093e \u092e\u093f\u0932\u0940\u0964 Microsoft \u0926\u094d\u0935\u093e\u0930\u093e \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0947 \u0915\u093e\u0930\u094d\u092f\u093e\u0928\u094d\u0935\u092f\u0928 \u0928\u0947 \u0907\u0938 \u0915\u094d\u0937\u0947\u0924\u094d\u0930 \u092e\u0947\u0902 \u090f\u0915 \u092e\u0939\u0924\u094d\u0935\u092a\u0942\u0930\u094d\u0923 \u092a\u094d\u0930\u0917\u0924\u093f \u0915\u094b \u091a\u093f\u0939\u094d\u0928\u093f\u0924 \u0915\u093f\u092f\u093e, \u091c\u093f\u0938\u0938\u0947 \u092f\u0939 \u0915\u0908 \u0906\u0927\u0941\u0928\u093f\u0915 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092a\u094d\u0930\u092c\u0902\u0927\u0928 \u092a\u094d\u0930\u0923\u093e\u0932\u093f\u092f\u094b\u0902 \u092e\u0947\u0902 \u090f\u0915 \u092e\u093e\u0928\u0915 \u0938\u0941\u0935\u093f\u0927\u093e \u092c\u0928 \u0917\u0908\u0964<\/p>\n<h2>SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092a\u0930 \u0935\u093f\u0938\u094d\u0924\u0943\u0924 \u091c\u093e\u0928\u0915\u093e\u0930\u0940<\/h2>\n<p>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u090f\u0915 \u0910\u0938\u0940 \u0924\u0915\u0928\u0940\u0915 \u0939\u0948 \u091c\u094b \u092a\u093e\u0930\u0902\u092a\u0930\u093f\u0915 \u092a\u0902\u0915\u094d\u0924\u093f-\u0906\u0927\u093e\u0930\u093f\u0924 \u0938\u094d\u091f\u094b\u0930\u0947\u091c \u0915\u0947 \u092c\u091c\u093e\u092f \u0915\u0949\u0932\u092e \u0926\u094d\u0935\u093e\u0930\u093e \u0921\u0947\u091f\u093e \u0915\u094b \u0935\u094d\u092f\u0935\u0938\u094d\u0925\u093f\u0924 \u0914\u0930 \u0938\u0902\u0917\u094d\u0930\u0939\u0940\u0924 \u0915\u0930\u0924\u0940 \u0939\u0948\u0964 \u092a\u0902\u0915\u094d\u0924\u093f-\u0906\u0927\u093e\u0930\u093f\u0924 \u0938\u094d\u091f\u094b\u0930\u0947\u091c \u092e\u0947\u0902, \u0924\u093e\u0932\u093f\u0915\u093e \u092e\u0947\u0902 \u0921\u0947\u091f\u093e \u092a\u0902\u0915\u094d\u0924\u093f \u0926\u0930 \u092a\u0902\u0915\u094d\u0924\u093f \u0938\u0902\u0917\u094d\u0930\u0939\u0940\u0924 \u0914\u0930 \u092a\u0941\u0928\u0930\u094d\u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u0907\u0938\u0915\u0947 \u0935\u093f\u092a\u0930\u0940\u0924, \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0947 \u0938\u093e\u0925, \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u0915\u0949\u0932\u092e \u0915\u0947 \u092d\u0940\u0924\u0930 \u0921\u0947\u091f\u093e \u0915\u094b \u090f\u0915 \u0938\u093e\u0925 \u0938\u0902\u0917\u094d\u0930\u0939\u0940\u0924 \u0914\u0930 \u0938\u0902\u0938\u093e\u0927\u093f\u0924 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948, \u091c\u093f\u0938\u0938\u0947 \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u092a\u094d\u0930\u0936\u094d\u0928\u094b\u0902 \u0915\u0947 \u0932\u093f\u090f \u092c\u0947\u0939\u0924\u0930 \u0938\u0902\u092a\u0940\u0921\u093c\u0928 \u0914\u0930 \u092c\u0947\u0939\u0924\u0930 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\n<p>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092a\u0922\u093c\u0928\u0947-\u0917\u0939\u0928 \u0915\u093e\u0930\u094d\u092f\u092d\u093e\u0930 \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u0941\u0915\u094d\u0924 \u0939\u0948\u0902, \u091c\u0939\u093e\u0902 \u0915\u094d\u0935\u0947\u0930\u0940\u091c\u093c \u092e\u0947\u0902 \u092c\u0921\u093c\u0940 \u092e\u093e\u0924\u094d\u0930\u093e \u092e\u0947\u0902 \u0921\u0947\u091f\u093e \u0914\u0930 \u090f\u0915\u0924\u094d\u0930\u0940\u0915\u0930\u0923 \u0936\u093e\u092e\u093f\u0932 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902\u0964 \u0935\u0947 \u0930\u093f\u092a\u094b\u0930\u094d\u091f\u093f\u0902\u0917, \u0921\u0947\u091f\u093e \u0935\u0947\u092f\u0930\u0939\u093e\u0909\u0938\u093f\u0902\u0917 \u0914\u0930 \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u0915\u094d\u0935\u0947\u0930\u0940\u091c\u093c \u0915\u094b \u092e\u0939\u0924\u094d\u0935\u092a\u0942\u0930\u094d\u0923 \u0930\u0942\u092a \u0938\u0947 \u0924\u0947\u091c\u093c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u0947 \u0932\u093f\u090f \u092c\u0921\u093c\u0947 \u0921\u0947\u091f\u093e \u0938\u0947\u091f \u0915\u094b \u0938\u094d\u0915\u0948\u0928 \u0915\u0930\u0928\u0947 \u0914\u0930 \u0938\u0902\u0938\u093e\u0927\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0964<\/p>\n<h2>\u0906\u0902\u0924\u0930\u093f\u0915 \u0938\u0902\u0930\u091a\u0928\u093e \u0914\u0930 \u0915\u093e\u0930\u094d\u092f\u092a\u094d\u0930\u0923\u093e\u0932\u0940<\/h2>\n<p>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0940 \u0906\u0902\u0924\u0930\u093f\u0915 \u0938\u0902\u0930\u091a\u0928\u093e \u0915\u0949\u0932\u092e \u0938\u0947\u0917\u092e\u0947\u0902\u091f \u0914\u0930 \u0936\u092c\u094d\u0926\u0915\u094b\u0936\u094b\u0902 \u092a\u0930 \u0906\u0927\u093e\u0930\u093f\u0924 \u0939\u094b\u0924\u0940 \u0939\u0948\u0964 \u0915\u0949\u0932\u092e \u0938\u0947\u0917\u092e\u0947\u0902\u091f \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u0915\u0949\u0932\u092e \u0915\u0947 \u0932\u093f\u090f \u0921\u0947\u091f\u093e \u0915\u0940 \u090f\u0915 \u0938\u0902\u092a\u0940\u0921\u093c\u093f\u0924 \u0907\u0915\u093e\u0908 \u0939\u0948\u0964 \u0907\u0938\u092e\u0947\u0902 \u0921\u0947\u091f\u093e \u092a\u0941\u0928\u0930\u094d\u092a\u094d\u0930\u093e\u092a\u094d\u0924\u093f \u0915\u094b \u0938\u0941\u0935\u093f\u0927\u093e\u091c\u0928\u0915 \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0928\u094d\u092f\u0942\u0928\u0924\u092e \u0914\u0930 \u0905\u0927\u093f\u0915\u0924\u092e \u092e\u093e\u0928\u094b\u0902 \u0938\u0939\u093f\u0924 \u092e\u0947\u091f\u093e\u0921\u0947\u091f\u093e \u0915\u0940 \u090f\u0915 \u0936\u094d\u0930\u0943\u0902\u0916\u0932\u093e \u0915\u0947 \u0938\u093e\u0925 \u092e\u0942\u0932\u094d\u092f\u094b\u0902 \u0915\u093e \u090f\u0915 \u0938\u0947\u091f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\n<p>\u0936\u092c\u094d\u0926\u0915\u094b\u0936\u094b\u0902 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0949\u0932\u092e \u092e\u0947\u0902 \u0926\u094b\u0939\u0930\u093e\u090f \u091c\u093e\u0928\u0947 \u0935\u093e\u0932\u0947 \u092e\u093e\u0928\u094b\u0902 \u0915\u094b \u0938\u0902\u092a\u0940\u0921\u093c\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u0935\u093e\u0938\u094d\u0924\u0935\u093f\u0915 \u092e\u093e\u0928\u094b\u0902 \u0915\u094b \u0915\u0908 \u092c\u093e\u0930 \u0938\u0902\u0917\u094d\u0930\u0939\u0940\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u091c\u093e\u092f, \u0936\u092c\u094d\u0926\u0915\u094b\u0936 \u0905\u0926\u094d\u0935\u093f\u0924\u0940\u092f \u092e\u093e\u0928\u094b\u0902 \u0914\u0930 \u0909\u0928\u0915\u0940 \u0938\u0902\u0917\u0924 \u0906\u0908\u0921\u0940 \u0915\u094b \u0938\u0902\u0917\u094d\u0930\u0939\u0940\u0924 \u0915\u0930\u0924\u093e \u0939\u0948, \u091c\u093f\u0938\u0938\u0947 \u092d\u0902\u0921\u093e\u0930\u0923 \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0915\u092e \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948 \u0914\u0930 \u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u092e\u0947\u0902 \u0938\u0941\u0927\u093e\u0930 \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\n<p>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092c\u0921\u093c\u0947 \u0921\u0947\u091f\u093e \u0938\u0947\u091f \u0915\u094b \u0915\u0941\u0936\u0932\u0924\u093e\u092a\u0942\u0930\u094d\u0935\u0915 \u0938\u094d\u0915\u0948\u0928 \u0914\u0930 \u092a\u094d\u0930\u094b\u0938\u0947\u0938 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092c\u0948\u091a \u092a\u094d\u0930\u094b\u0938\u0947\u0938\u093f\u0902\u0917 \u0928\u093e\u092e\u0915 \u0924\u0915\u0928\u0940\u0915 \u0915\u093e \u0932\u093e\u092d \u0909\u0920\u093e\u0924\u093e \u0939\u0948\u0964 \u092f\u0939 \u090f\u0915 \u0938\u093e\u0925 \u0915\u0908 \u092a\u0902\u0915\u094d\u0924\u093f\u092f\u094b\u0902 \u092a\u0930 \u0911\u092a\u0930\u0947\u0936\u0928 \u0915\u0930\u0924\u093e \u0939\u0948, \u091c\u094b \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u0915\u094d\u0935\u0947\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u094b \u092c\u0922\u093c\u093e\u0924\u093e \u0939\u0948\u0964<\/p>\n<h2>SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0940 \u092e\u0941\u0916\u094d\u092f \u0935\u093f\u0936\u0947\u0937\u0924\u093e\u090f\u0902<\/h2>\n<ul>\n<li>\n<p><strong>\u0906\u0927\u093e\u0930 - \u0938\u093e\u092e\u0917\u094d\u0930\u0940 \u0938\u0902\u0915\u094b\u091a\u0928<\/strong>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0905\u092a\u0928\u0947 \u0938\u094d\u0924\u0902\u092d\u0940\u092f \u092d\u0902\u0921\u093e\u0930\u0923 \u092a\u094d\u0930\u093e\u0930\u0942\u092a \u0914\u0930 \u0936\u092c\u094d\u0926\u0915\u094b\u0936-\u0906\u0927\u093e\u0930\u093f\u0924 \u0938\u0902\u092a\u0940\u0921\u093c\u0928 \u0924\u0915\u0928\u0940\u0915\u094b\u0902 \u0915\u0947 \u0915\u093e\u0930\u0923 \u0921\u0947\u091f\u093e \u092d\u0902\u0921\u093e\u0930\u0923 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e\u0913\u0902 \u0915\u094b \u0915\u093e\u092b\u0940 \u0915\u092e \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n<\/li>\n<li>\n<p><strong>\u092c\u0948\u091a \u092e\u094b\u0921 \u092a\u094d\u0930\u0938\u0902\u0938\u094d\u0915\u0930\u0923<\/strong>\u092a\u0902\u0915\u094d\u0924\u093f \u0926\u0930 \u092a\u0902\u0915\u094d\u0924\u093f \u0915\u0947 \u092c\u091c\u093e\u092f \u092c\u0948\u091a\u094b\u0902 \u092e\u0947\u0902 \u0921\u0947\u091f\u093e \u0915\u094b \u0938\u0902\u0938\u093e\u0927\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u0940 \u0915\u094d\u0937\u092e\u0924\u093e, \u092c\u0921\u093c\u0947 \u0921\u0947\u091f\u093e \u0938\u0947\u091f\u094b\u0902 \u0915\u0947 \u0932\u093f\u090f \u0924\u0947\u091c\u0940 \u0938\u0947 \u0915\u094d\u0935\u0947\u0930\u0940 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u0928 \u0915\u094b \u0938\u0915\u094d\u0937\u092e \u092c\u0928\u093e\u0924\u0940 \u0939\u0948\u0964<\/p>\n<\/li>\n<li>\n<p><strong>\u092a\u094d\u0930\u0947\u0921\u093f\u0915\u0947\u091f \u092a\u0941\u0936\u0921\u093e\u0909\u0928<\/strong>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092a\u094d\u0930\u0947\u0921\u093f\u0915\u0947\u091f \u092a\u0941\u0936\u0921\u093e\u0909\u0928 \u0915\u093e \u0938\u092e\u0930\u094d\u0925\u0928 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u091c\u093f\u0938\u0915\u093e \u0905\u0930\u094d\u0925 \u0939\u0948 \u0915\u093f \u0915\u094d\u0935\u0947\u0930\u0940 \u0911\u092a\u094d\u091f\u093f\u092e\u093e\u0907\u091c\u093c\u0930 \u0921\u0947\u091f\u093e \u0915\u094b \u092a\u0941\u0928\u0930\u094d\u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0938\u094d\u091f\u094b\u0930\u0947\u091c \u0938\u094d\u0924\u0930 \u092a\u0930 \u092b\u093c\u093f\u0932\u094d\u091f\u0930 \u0915\u0930 \u0938\u0915\u0924\u093e \u0939\u0948, \u091c\u093f\u0938\u0938\u0947 \u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u092e\u0947\u0902 \u0914\u0930 \u0935\u0943\u0926\u094d\u0927\u093f \u0939\u094b\u0924\u0940 \u0939\u0948\u0964<\/p>\n<\/li>\n<li>\n<p><strong>\u0935\u0947\u0915\u094d\u091f\u0930\u093e\u0907\u091c\u093c\u094d\u0921 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u0928<\/strong>: \u0921\u0947\u091f\u093e \u0915\u0947 \u0938\u0902\u092a\u0942\u0930\u094d\u0923 \u0935\u0947\u0915\u094d\u091f\u0930\u094b\u0902 \u092a\u0930 \u092a\u0930\u093f\u091a\u093e\u0932\u0928 \u090f\u0915 \u0938\u093e\u0925 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948, \u091c\u093f\u0938\u0915\u0947 \u092a\u0930\u093f\u0923\u093e\u092e\u0938\u094d\u0935\u0930\u0942\u092a \u0915\u094d\u0935\u0947\u0930\u0940 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u0928 \u0917\u0924\u093f \u092e\u0947\u0902 \u0938\u0941\u0927\u093e\u0930 \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\n<\/li>\n<\/ul>\n<h2>SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0947 \u092a\u094d\u0930\u0915\u093e\u0930<\/h2>\n<p>SQL \u092e\u0947\u0902 \u0926\u094b \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902:<\/p>\n<ol>\n<li>\n<p><strong>\u0915\u094d\u0932\u0938\u094d\u091f\u0930\u094d\u0921 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 (CCI)<\/strong>:<\/p>\n<ul>\n<li>\u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0915\u0947\u0935\u0932 \u090f\u0915 CCI \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948\u0964<\/li>\n<li>\u0938\u092e\u094d\u092a\u0942\u0930\u094d\u0923 \u0924\u093e\u0932\u093f\u0915\u093e \u0915\u094b \u0938\u0902\u092a\u0940\u0921\u093c\u093f\u0924 \u0938\u094d\u0924\u092e\u094d\u092d\u093e\u0915\u093e\u0930 \u092a\u094d\u0930\u093e\u0930\u0942\u092a \u092e\u0947\u0902 \u092a\u0930\u093f\u0935\u0930\u094d\u0924\u093f\u0924 \u0915\u0930 \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/li>\n<li>\u092c\u0921\u093c\u0947 \u0921\u0947\u091f\u093e \u0935\u0947\u092f\u0930\u0939\u093e\u0909\u0938\u093f\u0902\u0917 \u0914\u0930 \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u0915\u093e\u0930\u094d\u092f\u092d\u093e\u0930 \u0915\u0947 \u0932\u093f\u090f \u0906\u0926\u0930\u094d\u0936\u0964<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><strong>\u0928\u0949\u0928-\u0915\u094d\u0932\u0938\u094d\u091f\u0930 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 (\u090f\u0928\u0938\u0940\u0938\u0940\u0906\u0908)<\/strong>:<\/p>\n<ul>\n<li>\u090f\u0915 \u0939\u0940 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0905\u0928\u0947\u0915 \u090f\u0928\u0938\u0940\u0938\u0940\u0906\u0908 \u092c\u0928\u093e\u090f \u091c\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/li>\n<li>\u0915\u0947\u0935\u0932 \u091a\u092f\u0928\u093f\u0924 \u0938\u094d\u0924\u0902\u092d\u094b\u0902 \u0915\u094b \u0938\u0902\u092a\u0940\u0921\u093c\u093f\u0924 \u0938\u094d\u0924\u0902\u092d\u093e\u0915\u093e\u0930 \u092a\u094d\u0930\u093e\u0930\u0942\u092a \u092e\u0947\u0902 \u092a\u0930\u093f\u0935\u0930\u094d\u0924\u093f\u0924 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948, \u0924\u0925\u093e \u0936\u0947\u0937 \u0915\u094b \u092a\u0902\u0915\u094d\u0924\u093f-\u0906\u0927\u093e\u0930\u093f\u0924 \u092a\u094d\u0930\u093e\u0930\u0942\u092a \u092e\u0947\u0902 \u091b\u094b\u0921\u093c \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/li>\n<li>\u0910\u0938\u0947 \u092a\u0930\u093f\u0926\u0943\u0936\u094d\u092f\u094b\u0902 \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u0941\u0915\u094d\u0924 \u091c\u0939\u093e\u0902 \u0915\u0941\u091b \u0915\u0949\u0932\u092e\u094b\u0902 \u0915\u094b \u0905\u0928\u094d\u092f \u0915\u0940 \u0924\u0941\u0932\u0928\u093e \u092e\u0947\u0902 \u0905\u0927\u093f\u0915 \u092c\u093e\u0930 \u0915\u094d\u0935\u0947\u0930\u0940 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>\u0928\u0940\u091a\u0947 \u0926\u0940 \u0917\u0908 \u0924\u093e\u0932\u093f\u0915\u093e \u0938\u0940\u0938\u0940\u0906\u0908 \u0914\u0930 \u090f\u0928\u0938\u0940\u0938\u0940\u0906\u0908 \u0915\u0947 \u092c\u0940\u091a \u0905\u0902\u0924\u0930 \u0915\u094b \u0938\u093e\u0930\u093e\u0902\u0936\u093f\u0924 \u0915\u0930\u0924\u0940 \u0939\u0948:<\/p>\n<table>\n<thead>\n<tr>\n<th>\u0935\u093f\u0936\u0947\u0937\u0924\u093e<\/th>\n<th>\u0915\u094d\u0932\u0938\u094d\u091f\u0930\u094d\u0921 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 (CCI)<\/th>\n<th>\u0928\u0949\u0928-\u0915\u094d\u0932\u0938\u094d\u091f\u0930 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 (\u090f\u0928\u0938\u0940\u0938\u0940\u0906\u0908)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u0924\u093e\u0932\u093f\u0915\u093e \u0930\u0942\u092a\u093e\u0902\u0924\u0930\u0923<\/td>\n<td>\u0938\u0902\u092a\u0942\u0930\u094d\u0923 \u0924\u093e\u0932\u093f\u0915\u093e \u0915\u094b \u0938\u094d\u0924\u0902\u092d\u093e\u0915\u093e\u0930 \u092a\u094d\u0930\u093e\u0930\u0942\u092a \u092e\u0947\u0902 \u092a\u0930\u093f\u0935\u0930\u094d\u0924\u093f\u0924 \u0915\u0930 \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948<\/td>\n<td>\u0915\u0947\u0935\u0932 \u091a\u092f\u0928\u093f\u0924 \u0915\u0949\u0932\u092e \u0939\u0940 \u0930\u0942\u092a\u093e\u0902\u0924\u0930\u093f\u0924 \u0915\u093f\u090f \u091c\u093e\u0924\u0947 \u0939\u0948\u0902<\/td>\n<\/tr>\n<tr>\n<td>\u0905\u0928\u0941\u0915\u094d\u0930\u092e\u0923\u093f\u0915\u093e\u0913\u0902 \u0915\u0940 \u0938\u0902\u0916\u094d\u092f\u093e<\/td>\n<td>\u092a\u094d\u0930\u0924\u093f \u091f\u0947\u092c\u0932 \u0915\u0947\u0935\u0932 \u090f\u0915 CCI \u0915\u0940 \u0905\u0928\u0941\u092e\u0924\u093f \u0939\u0948<\/td>\n<td>\u090f\u0915 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0915\u0908 NCCI \u092c\u0928\u093e\u090f \u091c\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/td>\n<\/tr>\n<tr>\n<td>\u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928<\/td>\n<td>\u092a\u0942\u0930\u094d\u0923 \u0938\u094d\u0924\u0902\u092d\u093e\u0915\u093e\u0930 \u092d\u0902\u0921\u093e\u0930\u0923 \u0915\u0947 \u0915\u093e\u0930\u0923 \u0938\u093e\u092e\u093e\u0928\u094d\u092f\u0924\u0903 \u0924\u0947\u091c\u093c<\/td>\n<td>\u0915\u094d\u0935\u0947\u0930\u0940 \u0915\u093e \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u0949\u0932\u092e \u091a\u092f\u0928 \u092a\u0930 \u0928\u093f\u0930\u094d\u092d\u0930 \u0915\u0930\u0924\u093e \u0939\u0948<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u0909\u092a\u092f\u094b\u0917, \u091a\u0941\u0928\u094c\u0924\u093f\u092f\u093e\u0901 \u0914\u0930 \u0938\u092e\u093e\u0927\u093e\u0928<\/h2>\n<p>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u0915\u094d\u0935\u0947\u0930\u0940\u091c\u093c \u0915\u0947 \u0932\u093f\u090f \u0905\u0924\u094d\u092f\u0927\u093f\u0915 \u0932\u093e\u092d\u0915\u093e\u0930\u0940 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0928\u092e\u0947\u0902 \u092c\u0921\u093c\u0947 \u092a\u0948\u092e\u093e\u0928\u0947 \u092a\u0930 \u0921\u0947\u091f\u093e \u092a\u094d\u0930\u094b\u0938\u0947\u0938\u093f\u0902\u0917 \u0936\u093e\u092e\u093f\u0932 \u0939\u094b\u0924\u0940 \u0939\u0948\u0964 \u0939\u093e\u0932\u093e\u0901\u0915\u093f, \u0935\u0947 OLTP (\u0911\u0928\u0932\u093e\u0907\u0928 \u091f\u094d\u0930\u093e\u0902\u091c\u0947\u0915\u094d\u0936\u0928 \u092a\u094d\u0930\u094b\u0938\u0947\u0938\u093f\u0902\u0917) \u0915\u093e\u0930\u094d\u092f\u092d\u093e\u0930 \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u0941\u0915\u094d\u0924 \u0928\u0939\u0940\u0902 \u0939\u094b \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u091c\u093f\u0938\u092e\u0947\u0902 \u0905\u0915\u094d\u0938\u0930 \u091b\u094b\u091f\u0947 \u092a\u0948\u092e\u093e\u0928\u0947 \u092a\u0930 \u0932\u0947\u0928\u0926\u0947\u0928 \u0914\u0930 \u0905\u092a\u0921\u0947\u091f \u0936\u093e\u092e\u093f\u0932 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902\u0964 \u0910\u0938\u0947 \u092a\u0930\u093f\u0926\u0943\u0936\u094d\u092f\u094b\u0902 \u092e\u0947\u0902, \u092a\u093e\u0930\u0902\u092a\u0930\u093f\u0915 \u092a\u0902\u0915\u094d\u0924\u093f-\u0906\u0927\u093e\u0930\u093f\u0924 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092c\u0947\u0939\u0924\u0930 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n<p>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0938\u0947 \u091c\u0941\u0921\u093c\u0940 \u091a\u0941\u0928\u094c\u0924\u093f\u092f\u094b\u0902 \u092e\u0947\u0902 \u0936\u093e\u092e\u093f\u0932 \u0939\u0948\u0902:<\/p>\n<ul>\n<li>\n<p><strong>\u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0921\u093e\u0932\u0947\u0902 \u0914\u0930 \u0905\u092a\u0921\u0947\u091f \u0915\u0930\u0947\u0902<\/strong>\u092a\u0902\u0915\u094d\u0924\u093f-\u0906\u0927\u093e\u0930\u093f\u0924 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0940 \u0924\u0941\u0932\u0928\u093e \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092e\u0947\u0902 \u0927\u0940\u092e\u0940 \u092a\u094d\u0930\u0935\u093f\u0937\u094d\u091f\u093f \u0914\u0930 \u0905\u0926\u094d\u092f\u0924\u0928 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u0940 \u0938\u092e\u0938\u094d\u092f\u093e \u0939\u094b \u0938\u0915\u0924\u0940 \u0939\u0948, \u0915\u094d\u092f\u094b\u0902\u0915\u093f \u0907\u0937\u094d\u091f\u0924\u092e \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u0947 \u0932\u093f\u090f \u0909\u0928\u094d\u0939\u0947\u0902 \u0921\u0947\u091f\u093e \u0915\u094b \u092c\u0932\u094d\u0915-\u0932\u094b\u0921 \u0915\u0930\u0928\u0947 \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0964<\/p>\n<\/li>\n<li>\n<p><strong>\u0921\u0947\u0932\u094d\u091f\u093e \u0938\u094d\u091f\u094b\u0930<\/strong>\u0905\u092a\u0921\u0947\u091f \u0915\u094b \u0915\u0941\u0936\u0932\u0924\u093e\u092a\u0942\u0930\u094d\u0935\u0915 \u0938\u0902\u092d\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f, SQL \u0938\u0930\u094d\u0935\u0930 \u0905\u092a\u094d\u0930\u0924\u093f\u092c\u0926\u094d\u0927 \u0921\u0947\u091f\u093e \u0915\u0947 \u0932\u093f\u090f \u0921\u0947\u0932\u094d\u091f\u093e \u0938\u094d\u091f\u094b\u0930 \u092c\u0928\u093e\u090f \u0930\u0916\u0924\u093e \u0939\u0948, \u091c\u093f\u0938\u0947 \u0938\u092e\u092f-\u0938\u092e\u092f \u092a\u0930 \u092e\u0941\u0916\u094d\u092f \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u092e\u0947\u0902 \u092e\u0930\u094d\u091c \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u092f\u0939 \u092a\u094d\u0930\u0915\u094d\u0930\u093f\u092f\u093e \u092e\u0930\u094d\u091c \u0915\u0947 \u0926\u094c\u0930\u093e\u0928 \u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u094b \u092a\u094d\u0930\u092d\u093e\u0935\u093f\u0924 \u0915\u0930 \u0938\u0915\u0924\u0940 \u0939\u0948\u0964<\/p>\n<\/li>\n<\/ul>\n<p>\u0907\u0928 \u091a\u0941\u0928\u094c\u0924\u093f\u092f\u094b\u0902 \u0915\u0947 \u0938\u092e\u093e\u0927\u093e\u0928 \u092e\u0947\u0902 \u0936\u093e\u092e\u093f\u0932 \u0939\u0948\u0902:<\/p>\n<ul>\n<li>\n<p><strong>\u092c\u0948\u091a \u0905\u092a\u0921\u0947\u091f<\/strong>: \u092c\u0921\u093c\u0947 \u092c\u0948\u091a\u094b\u0902 \u092e\u0947\u0902 \u0905\u0926\u094d\u092f\u0924\u0928 \u0915\u0930\u0928\u0947 \u0938\u0947 \u0921\u0947\u0932\u094d\u091f\u093e \u0938\u094d\u091f\u094b\u0930 \u092e\u0930\u094d\u091c \u0915\u0940 \u0906\u0935\u0943\u0924\u094d\u0924\u093f \u0915\u092e \u0915\u0930\u0915\u0947 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u092e\u0947\u0902 \u0938\u0941\u0927\u093e\u0930 \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0924\u093e \u0939\u0948\u0964<\/p>\n<\/li>\n<li>\n<p><strong>\u0921\u0947\u091f\u093e \u0935\u093f\u092d\u093e\u091c\u0928<\/strong>\u0921\u0947\u091f\u093e \u0915\u094b \u091b\u094b\u091f\u0940 \u0907\u0915\u093e\u0907\u092f\u094b\u0902 \u092e\u0947\u0902 \u0935\u093f\u092d\u093e\u091c\u093f\u0924 \u0915\u0930\u0928\u0947 \u0938\u0947 \u0924\u0947\u091c\u0940 \u0938\u0947 \u0938\u092e\u094d\u092e\u093f\u0932\u093f\u0924 \u0915\u0930\u0928\u0947 \u0914\u0930 \u0905\u0926\u094d\u092f\u0924\u0928 \u0915\u0930\u0928\u0947 \u092e\u0947\u0902 \u0938\u0939\u093e\u092f\u0924\u093e \u092e\u093f\u0932 \u0938\u0915\u0924\u0940 \u0939\u0948\u0964<\/p>\n<\/li>\n<\/ul>\n<h2>\u0935\u093f\u0936\u0947\u0937\u0924\u093e\u090f\u0901 \u0914\u0930 \u0924\u0941\u0932\u0928\u093e\u090f\u0901<\/h2>\n<p>\u0906\u0907\u090f \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u0940 \u0924\u0941\u0932\u0928\u093e \u0938\u092e\u093e\u0928 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0938\u0941\u0935\u093f\u0927\u093e\u0913\u0902 \u0938\u0947 \u0915\u0930\u0947\u0902:<\/p>\n<table>\n<thead>\n<tr>\n<th>\u0935\u093f\u0936\u0947\u0937\u0924\u093e<\/th>\n<th>\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938<\/th>\n<th>\u0930\u094b\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u092d\u0902\u0921\u093e\u0930\u0923 \u092a\u094d\u0930\u093e\u0930\u0942\u092a<\/td>\n<td>\u0938\u094d\u0924\u0902\u092d\u093e\u0915\u093e\u0930 \u092d\u0902\u0921\u093e\u0930\u0923<\/td>\n<td>\u092a\u0902\u0915\u094d\u0924\u093f-\u0906\u0927\u093e\u0930\u093f\u0924 \u092d\u0902\u0921\u093e\u0930\u0923<\/td>\n<\/tr>\n<tr>\n<td>\u0926\u092c\u093e\u0935<\/td>\n<td>\u0909\u091a\u094d\u091a \u0938\u0902\u092a\u0940\u0921\u093c\u0928 \u0905\u0928\u0941\u092a\u093e\u0924<\/td>\n<td>\u0915\u092e \u0938\u0902\u092a\u0940\u0921\u093c\u0928 \u0905\u0928\u0941\u092a\u093e\u0924<\/td>\n<\/tr>\n<tr>\n<td>\u0915\u094d\u0935\u0947\u0930\u0940 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928<\/td>\n<td>\u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923\u093e\u0924\u094d\u092e\u0915 \u092a\u094d\u0930\u0936\u094d\u0928\u094b\u0902 \u0915\u0947 \u0932\u093f\u090f \u0924\u0947\u091c\u093c<\/td>\n<td>OLTP \u0915\u094d\u0935\u0947\u0930\u0940\u091c\u093c \u0915\u0947 \u0932\u093f\u090f \u0924\u0947\u091c\u093c<\/td>\n<\/tr>\n<tr>\n<td>\u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0921\u093e\u0932\u0947\u0902 \u0914\u0930 \u0905\u092a\u0921\u0947\u091f \u0915\u0930\u0947\u0902<\/td>\n<td>\u0935\u094d\u092f\u0915\u094d\u0924\u093f\u0917\u0924 \u0905\u092a\u0921\u0947\u091f \u0915\u0947 \u0932\u093f\u090f \u0927\u0940\u092e\u093e<\/td>\n<td>\u0935\u094d\u092f\u0915\u094d\u0924\u093f\u0917\u0924 \u0905\u092a\u0921\u0947\u091f \u0915\u0947 \u0932\u093f\u090f \u0924\u0947\u091c\u093c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u092a\u0930\u093f\u092a\u094d\u0930\u0947\u0915\u094d\u0937\u094d\u092f \u0914\u0930 \u092d\u0935\u093f\u0937\u094d\u092f \u0915\u0940 \u092a\u094d\u0930\u094c\u0926\u094d\u092f\u094b\u0917\u093f\u0915\u093f\u092f\u093e\u0901<\/h2>\n<p>\u091c\u0948\u0938\u0947-\u091c\u0948\u0938\u0947 \u0921\u0947\u091f\u093e \u0924\u0947\u091c\u0940 \u0938\u0947 \u092c\u0922\u093c\u0924\u093e \u091c\u093e \u0930\u0939\u093e \u0939\u0948, \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0906\u0927\u0941\u0928\u093f\u0915 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0915\u093e \u090f\u0915 \u092e\u0939\u0924\u094d\u0935\u092a\u0942\u0930\u094d\u0923 \u0918\u091f\u0915 \u092c\u0928\u093e \u0930\u0939\u0947\u0917\u093e\u0964 \u092d\u0935\u093f\u0937\u094d\u092f \u0915\u0940 \u092a\u094d\u0930\u0917\u0924\u093f \u0905\u092a\u0921\u0947\u091f \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u091a\u0941\u0928\u094c\u0924\u093f\u092f\u094b\u0902 \u0915\u094b \u0938\u0902\u092c\u094b\u0927\u093f\u0924 \u0915\u0930\u0928\u0947 \u0914\u0930 \u0914\u0930 \u092d\u0940 \u0905\u0927\u093f\u0915 \u0915\u0941\u0936\u0932 \u0938\u0902\u092a\u0940\u0921\u093c\u0928 \u090f\u0932\u094d\u0917\u094b\u0930\u093f\u0926\u092e \u092a\u094d\u0930\u0926\u093e\u0928 \u0915\u0930\u0928\u0947 \u092a\u0930 \u0927\u094d\u092f\u093e\u0928 \u0915\u0947\u0902\u0926\u094d\u0930\u093f\u0924 \u0915\u0930 \u0938\u0915\u0924\u0940 \u0939\u0948\u0964<\/p>\n<h2>SQL \u092e\u0947\u0902 \u092a\u094d\u0930\u0949\u0915\u094d\u0938\u0940 \u0938\u0930\u094d\u0935\u0930 \u0914\u0930 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938<\/h2>\n<p>OneProxy \u0926\u094d\u0935\u093e\u0930\u093e \u092a\u094d\u0930\u0926\u093e\u0928 \u0915\u093f\u090f \u0917\u090f \u092a\u094d\u0930\u0949\u0915\u094d\u0938\u0940 \u0938\u0930\u094d\u0935\u0930 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 SQL \u0938\u0930\u094d\u0935\u0930 \u092a\u0930\u093f\u0928\u093f\u092f\u094b\u091c\u0928 \u0915\u0947 \u092a\u094d\u0930\u0926\u0930\u094d\u0936\u0928 \u0915\u094b \u092c\u0922\u093c\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u092a\u094d\u0930\u0949\u0915\u094d\u0938\u0940 \u0938\u0930\u094d\u0935\u0930 \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 SQL \u0915\u094d\u0935\u0947\u0930\u0940 \u0915\u094b \u0930\u0942\u091f \u0915\u0930\u0915\u0947, \u0938\u0902\u0917\u0920\u0928 \u0915\u0941\u091b \u092a\u094d\u0930\u094b\u0938\u0947\u0938\u093f\u0902\u0917 \u0913\u0935\u0930\u0939\u0947\u0921 \u0915\u094b \u0911\u092b\u0932\u094b\u0921 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0938\u0902\u092d\u093e\u0935\u093f\u0924 \u0930\u0942\u092a \u0938\u0947 \u0926\u0942\u0930\u0938\u094d\u0925 \u0915\u094d\u0932\u093e\u0907\u0902\u091f \u0915\u0947 \u0932\u093f\u090f \u092a\u094d\u0930\u0924\u093f\u0915\u094d\u0930\u093f\u092f\u093e \u0938\u092e\u092f \u092e\u0947\u0902 \u0938\u0941\u0927\u093e\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938\u0915\u0947 \u0905\u0924\u093f\u0930\u093f\u0915\u094d\u0924, OneProxy \u0915\u0940 \u0932\u094b\u0921 \u092c\u0948\u0932\u0947\u0902\u0938\u093f\u0902\u0917 \u0915\u094d\u0937\u092e\u0924\u093e\u090f\u0901 \u0915\u094d\u0935\u0947\u0930\u0940 \u0915\u094b \u0938\u092e\u093e\u0928 \u0930\u0942\u092a \u0938\u0947 \u0935\u093f\u0924\u0930\u093f\u0924 \u0915\u0930\u0928\u0947 \u092e\u0947\u0902 \u092e\u0926\u0926 \u0915\u0930 \u0938\u0915\u0924\u0940 \u0939\u0948\u0902, \u091c\u093f\u0938\u0938\u0947 \u0938\u0902\u0938\u093e\u0927\u0928 \u0909\u092a\u092f\u094b\u0917 \u0915\u093e \u0905\u0928\u0941\u0915\u0942\u0932\u0928 \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\n<h2>\u0938\u092e\u094d\u092c\u0902\u0927\u093f\u0924 \u0932\u093f\u0902\u0915\u094d\u0938<\/h2>\n<p>SQL \u092e\u0947\u0902 \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092a\u0930 \u0905\u0927\u093f\u0915 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f, \u0928\u093f\u092e\u094d\u0928\u0932\u093f\u0916\u093f\u0924 \u0938\u0902\u0938\u093e\u0927\u0928\u094b\u0902 \u0915\u093e \u0938\u0902\u0926\u0930\u094d\u092d \u0932\u0947\u0902:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-overview?view=sql-server-ver15\" target=\"_new\" rel=\"noopener nofollow\">\u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u092a\u0930 Microsoft \u0926\u0938\u094d\u0924\u093e\u0935\u0947\u091c\u093c<\/a><\/li>\n<li><a href=\"https:\/\/www.sqlservercentral.com\/steps\/columnstore-indexes-introduction\" target=\"_new\" rel=\"noopener nofollow\">SQL \u0938\u0930\u094d\u0935\u0930 \u0938\u0947\u0902\u091f\u094d\u0930\u0932: \u0915\u0949\u0932\u092e\u0938\u094d\u091f\u094b\u0930 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u093e \u092a\u0930\u093f\u091a\u092f<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/hub\/product-learning\/sql-prompt\/development-and-testing-benefits-of-data-compression-in-sql-server\" target=\"_new\" rel=\"noopener nofollow\">SQL \u0938\u0930\u094d\u0935\u0930 \u092e\u0947\u0902 \u0921\u0947\u091f\u093e \u0938\u0902\u092a\u0940\u0921\u093c\u0928<\/a><\/li>\n<\/ul>","protected":false},"featured_media":467910,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-476326","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Columnstore Indexes in SQL: An Overview<\/mark>","faq_items":[{"question":"What are Columnstore indexes in SQL, and how do they work?","answer":"<p>Columnstore indexes in SQL are a database feature that organizes and stores data in a columnar format rather than the traditional row-based storage. This arrangement allows for improved data compression and faster query performance for analytical workloads. Data within each column is stored and processed together, leveraging batch processing techniques. The indexes consist of column segments and dictionaries, which facilitate efficient data retrieval and compression.<\/p>"},{"question":"What is the history behind the origin of Columnstore indexes in SQL?","answer":"<p>Columnstore indexes in SQL were first introduced by Microsoft with the release of SQL Server 2012. The concept of columnar storage has been around since the 1970s, but it gained popularity in the mid-2000s with the rise of big data and the need for better data compression and query performance. Microsoft's implementation marked a significant advancement in this area, making it a standard feature in modern database management systems.<\/p>"},{"question":"How do Clustered Columnstore Indexes (CCI) differ from Non-Clustered Columnstore Indexes (NCCI)?","answer":"<p>Clustered Columnstore Indexes (CCI) convert the entire table into a columnar format, allowing only one CCI per table. On the other hand, Non-Clustered Columnstore Indexes (NCCI) allow multiple indexes on a single table and only convert selected columns into a columnar format. CCI tends to have faster query performance due to complete columnar storage, while NCCI's performance depends on the selection of columns.<\/p>"},{"question":"What are the key features of Columnstore indexes in SQL?","answer":"<p>Some key features of Columnstore indexes include:<\/p><ul><li>High data compression ratios, leading to reduced storage requirements.<\/li><li>Batch mode processing for faster execution of large analytical queries.<\/li><li>Predicate pushdown, allowing for filtering data at the storage level before retrieval.<\/li><li>Vectorized execution for improved query execution speeds.<\/li><\/ul>"},{"question":"What are the main challenges faced with Columnstore indexes?","answer":"<p>While Columnstore indexes offer significant benefits for analytical queries, they can present challenges, such as slower insert and update performance. This is due to the need for bulk loading data for optimal performance. Additionally, the maintenance of a Delta Store for uncommitted data can impact query performance during merges.<\/p>"},{"question":"How can organizations overcome the challenges of Columnstore indexes?","answer":"<p>To improve insert and update performance, organizations can opt for batch updates, performing updates in larger batches. Segmenting data into smaller units can also aid in faster insert and update operations.<\/p>"},{"question":"How can OneProxy's proxy servers enhance SQL Server deployments with Columnstore indexes?","answer":"<p>OneProxy's proxy servers can optimize SQL Server deployments using Columnstore indexes by offloading some processing overhead and potentially improving response times for remote clients. Additionally, OneProxy's load balancing capabilities help distribute queries evenly, optimizing resource usage and enhancing overall performance.<\/p>"},{"question":"What is the future outlook for Columnstore indexes in SQL?","answer":"<p>Columnstore indexes are expected to remain a crucial component of modern databases as data continues to grow exponentially. Future advancements may focus on addressing challenges related to updates and providing even more efficient compression algorithms.<\/p>"},{"question":"Where can I find more information about Columnstore indexes in SQL?","answer":"<p>For more in-depth insights on Columnstore indexes in SQL, you can refer to the following resources:<\/p><ul><li>Microsoft Docs on Columnstore Indexes: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-overview?view=sql-server-ver15\" target=\"_new\">Link<\/a><\/li><li>SQL Server Central: Introduction to Columnstore Indexes: <a href=\"https:\/\/www.sqlservercentral.com\/steps\/columnstore-indexes-introduction\" target=\"_new\">Link<\/a><\/li><li>Data Compression in SQL Server: <a href=\"https:\/\/www.red-gate.com\/hub\/product-learning\/sql-prompt\/development-and-testing-benefits-of-data-compression-in-sql-server\" target=\"_new\">Link<\/a><\/li><\/ul>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/in\/wp-json\/wp\/v2\/wiki\/476326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/in\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/in\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/in\/wp-json\/wp\/v2\/wiki\/476326\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/in\/wp-json\/wp\/v2\/media\/467910"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/in\/wp-json\/wp\/v2\/media?parent=476326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}