page336
424
performance tuning, 69
spill to disk/OOM, 88–91
database, 40
declared warehouse, 50
example query, 53, 55, 56
developing query, 54
materializing, 59–63
profiling, 56–59
result count, 53
explain plan, 66, 67
GET_QUERY_OPERATOR_STATS, 68
good profile, 64–66
initial population, 46–50
query plan, 39
setup, 41–45
TPC data model, 46
Query tags, 198
R
Refactoring, 7
Referenced objects
GET_DDL, 393, 394
identifying constraints, 392, 393
identifying object types, 388–390
object dependencies, 390–392
tables and views, 388
Relational database management system
(RDBMS), 4, 146, 349
Role-based access control (RBAC), 7, 349
“Rules-based” approach, 15
S
Search access paths, 247
Search optimization, 405
Search optimization service (SOS)
definition, 267
disabling table, 265
implementation
enabling attribute, 256, 257
enabling SOS, 254, 256
table-by-table basis, 252, 254
TPC environment, 251
optimal patterns, 268
optimal performance and cost, 248
serverless compute feature, 247, 248
service, 249–251
table types, 265
dynamic table, 260–262
standard table, 258
temporary tables, 264
transient tables, 262, 263
timeliness, 266
Service-level agreements (SLAs), 220, 282
SHOW command, 115, 389
SHOW OBJECTS command, 389
Single Instruction, Multiple Data
(SIMD), 34
SnowConvert, 9, 11
Snowflake data cloud
data profiles, 2
introspection calls, 21
optimization, 14, 15
optimizer statistics, 22, 23
performance optimization, 1
setting scene
CSP, 4
greenfield development, 12
migration, 7
out-of-the-box developer, 3
performance tuning, 3
provision-based infrastructure, 3
provision/consumption model, 5, 6
refactor/redesign, 7
Query profiler (
cont.
)
INDEX