We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Setting locale while running query — Vertica Forum

Setting locale while running query

Navin_CNavin_C Vertica Customer ✭
in General Discussion
Hello,

I am trying to optimize a query.
According to observation a query runs better if set to default locale, but we use LEN_S1 locale for database.

Is there any specific hint, we can give to query so that it runs on default LOCALE or any other locale. Similar to what we use with DIRECT keyword

Thanks.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...