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\ p7pdeoov7rn876uxmb29f set up data encryption docid 8vnnuy5udinjo50iik21a authentication methods docid\ rurudicbkdqxfu y99p1r database password security settings docid\ jfltms91v2bfledppksy8 user control these pages explain ocient user management, including controlling security and priority for user groups manage users, groups, and roles docid\ k rpf30u 1c3jfq 7ahiu workload management and service classes docid\ iiyevxztwxxvyqeuhfi2t workload management walkthrough docid\ sf8ojgyg8bqcetvtpj87c object type level privileges management docid\ mqfbwzxff95wlq4flpobn 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 7asr7i8qb0jlunvq9tzq secondary indexes docid\ a5odjf1wlmeacsfrr8k4m create table sql statement examples docid\ veeoxedu opmz9xm0qqac manage distributed tasks docid\ nciheom sgkckc1rybggi storage these pages explain compression and caching options in the ocient system table compression options docid\ dfaledfc0jdwsfsar3pav global dictionary compression docid 3jftkb yrchqx3350odqp result set caching docid\ tnfsbqqn4feyztn0f dbn remove records from an ocient system docid\ ubdqnmju5stv aqfavviz sql reference pages for detailed documentation on supported ddl or dcl commands and syntax, see general sql syntax docid\ nw9vavkey2v75moxm muo data definition language (ddl) statement reference docid\ jf l ie2lupbjgrjw4lqx data control language (dcl) statement reference docid\ f55ngxtki0f7kkmyatvug related links connect to ocient docid\ tyktrvrfpdxdnt9gnwbrh ingest data with legacy lat reference docid\ zjlpeecj74 lp0ciflqh0