![]() If a query uses a range-restricted predicate, the query processorĬan use the min and max values to rapidly skip over large numbers of blocks during table The min and max values for each block are stored as Amazon Redshift storesĬolumnar data in 1 MB disk blocks. Sorting enables efficient handling of range-restricted predicates. Query planner, and the planner uses this information to construct plans that exploit the Information about sort key columns is passed to the When data is initially loaded into the empty table, the rows are When you create a table, you can alternatively define one or more of its columns as sort ![]() The rest of this section provides details about the sort order. If you do so, then Amazon Redshift usesĪutomatic table optimization to choose the sort key.įor more information, see Working with automatic table optimization. We recommend that you create your tables with SORTKEY AUTO. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |