Database Administration

database administrators are responsible for ensuring the smooth operation of an {{ocient}} 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 1ho3lyq846wudwkwdsehi set up data encryption docid\ shv0qnx m fif0b2f8qpu authentication methods docid\ q q8xchwkgyrpviv2a3bd database password security settings docid\ kuzemuw8ipvp0dzq 5dea user control these pages explain ocient user management, including controlling security and priority for user groups manage users, groups, and roles docid\ wkvhkkgw5oa1l6atnnlra workload management and service classes docid\ uipqmzfpmkmbcsardkoqs workload management walkthrough docid\ f4egzuqnhpxncfl39bm2j object type level privileges management docid\ r9wkkrvu wwz b8bcb9d9 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\ oxu8ziws8csyc5h7l4xxm secondary indexes docid\ efbuyqjp 9ole py4jpst create table sql statement examples docid\ tiepjiw1hwpqcf0v5ec84 manage distributed tasks docid\ xlanrienmdxkp3tmf1hhd storage these pages explain compression and caching options in the ocient system table compression options docid\ cjq7ia90yenazchewq4r0 global dictionary compression docid\ za8zgoyol4aars3i9pchc result set caching docid\ hxrqo jxhhfeqbczpwpxi remove records from an ocient system docid\ ajpptr0os8zq3f 0lue m sql reference pages for detailed documentation on supported ddl or dcl commands and syntax, see general sql syntax docid\ ijazgahmd u0x4gsmz8e1 data definition language (ddl) statement reference docid\ e36p0yk3fcwdnuiimxkn2 data control language (dcl) statement reference docid\ cq7pzjpzxsakbbsqsumai related links connect to ocient docid 3ogdk ko9evjyfqgs6n5h ingest data with legacy lat reference docid ul5nilgyd7y wjccg59d