After you sign on and have your account ready, you can use SQL Editor to create a connection and submit a query. You can also connect to your database from Teradata Studio and submit a query.
All SELECT DML are supported for Object File System tables. See SQL Data Manipulation Language for details on syntax and usages.
With the options to store data in different storages, different types of queries performs differently.
- For tactical or short SLA requests that require quick response time, it is beneficial to store data on primary cluster block storagewhich has small latency. However, because of the cost, you may store only a small subset of the customer data there.Single Table Join Index can be used for tactical queries. See Join Index for details about STJI.Single Table Join Indexes are supported for Object File System tables on the primary cluster. You must use the STORAGE clause when creating the join, such as the following:
CREATE JOIN INDEX table_name1 1 , NO Fallback , STORAGE=ofs_storage_name AS ( SELECT column_name1, column_name2 FROM table_name2 ) ORDER BY ( column_name1) ;
- For analytics and long-running queries, if the tables are big but execution process is not time-sensitive, it is a good option to store the data in object storage such as in the Object File System. It has higher latency, but the cost is lower compared to the persistent block-level storage in the primary cluster.