What does "sorting projections on spatial columns" mean in Vertica Places ?

In Vertica Place documentation it says  "Consider sorting projections on spatial
columns to improve the performance  of .... ".

What does this mean in technical terms ? Assigning space filling curve values for objects so that the algorithm can filter them during the query processing ?


  • Options
    Hi Ablimit, 
    This is just a heads up that we are migrating this Community to a new platform in the next couple of days. We’ll make every effort to answer your question before that…but if it remains open, please do visit our new forum and pose your question once again. You’ll find the new forum here: https://community.dev.hp.com/t5/Big-Data-and-Analytics/ct-p/bigdata_analytics. Please visit us on Thursday!

  • Options
    Ariel_CaryAriel_Cary Vertica Employee Employee
    Hi Ablimit.

    The idea of sorting by a geometry column is to group geometries nearby in the space, which are likely going to be accessed together (e.g., range query), so that a (large, irrelevant) number of geometries can be pruned during query processing. Vertica uses an encoding of the geometries to determine order, but doesn't modify data while sorting.

    Hope this helps.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file