deeejay

TSQL - Hash Tables

Jul 11th, 2023
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE [dbo].[BusinessHierarchies](
  2. [BookId] [nvarchar](250) ,
  3. [Division] [nvarchar](100) ,
  4. [Cluster] [nvarchar](100) ,
  5. [Desk] [nvarchar](100) ,
  6. [Book] [nvarchar](100) ,
  7. [Volcker] [nvarchar](100) ,
  8. [Region] [nvarchar](100)
  9. )
  10. WITH
  11. (
  12. CLUSTERED COLUMSTORE INDEX
  13. , DISTRIBUTION = HASH([Volcker])
  14. )
  15. ;
Advertisement
Add Comment
Please, Sign In to add comment