Database Administration

database administrators are responsible for ensuring the smooth operation of an system and learning how to maximize performance to meet the goals of their organization see these pages for key concepts that are useful for understanding ocient system dynamics and managing users tutorials security these pages explain system authentication, sso, network security, and encryption options ocient security guide docid\ ozpx76 uj xnyo dvjsm set up data encryption docid\ j0vufzibkhw6rnlpqwmqp authentication methods docid\ fq5qmoebhw9ylcshl bt database password security settings docid\ jsbh ri7v6def1rje6eoh user control these pages explain ocient user management, including controlling security and priority for user groups manage users, groups, and roles docid\ kg5gprnodkng9eigkxp5i workload management and service classes docid\ e8ehcdkbyl8blwwacosvx workload management walkthrough docid 9kxhilhqndr 2zpuqjx9x object type level privileges management docid 2wqnurrbldr2izkfdcexa query performance and tuning configure keys and indexes before loading large amounts of data into a table these pages provide detailed information on how to optimize query performance by setting up ocient keys and indexing timekeys and clustering keys docid\ tfr hznzvabrm8wqf46lm secondary indexes docid\ xmmylaxzqfci6ysnff5tg create table sql statement examples docid m9x5vuwbb5i 09wfbmqv manage distributed tasks docid\ g fncnhsvg9jpq88u2wqc storage these pages explain compression and caching options in the ocient system table compression options docid 9dknfvlmwhmwtb3 pay09 global dictionary compression docid\ jgyc ya34xazt9dwvccfq result set caching docid 9fvbwkepgkiqpiz9vnejm remove records from an ocient system docid\ s67tmglyp6nefqd3yxox7 sql reference pages for detailed documentation on supported ddl or dcl commands and syntax, see general sql syntax docid\ jgnyaywtjqwrpigkg uvk data definition language (ddl) statement reference docid\ ovrtwnzs3ue2vlucq3koh data control language (dcl) statement reference docid\ otlj4xmmckz1yfviq9vxu related links connect to ocient docid\ bz8g2ykkd26fmwpywjbuu ingest data with legacy lat reference docid\ ojlxwqbiokfcar alnhuo