CODEWITHSUNDEEP
sqlsnowflake-cloud-data-platform
user3456025
user3456025

Reputation: 1

Snowflake SQL Performance question - select

Currently we are using snowflake to query the database and curious if the following hinders performance.

Select column_a::varchar(16777216) from view vs Select column_a::varchar(100) from view

As you can see the precision is very different. Does this have any impact on performance?

Also what do you call in SQL when someone puts ::datatype?

Please let me know.

Upvotes: 0

Views: 1036

Answers (1)

Pankaj
Pankaj

Reputation: 2746

Please refer = https://docs.snowflake.com/en/sql-reference/data-types-text.html#varchar There is no performance difference between using the full-length VARCHAR declaration VARCHAR(16777216) or a smaller length.

Upvotes: 1

Related Questions