Advanced Features
This section details a selection of advanced features of the Amazon DynamoDB add-in.
Automatic Index Detection
The AutoDetectIndex property provides fast access to items in a table by detecting an alternate index which can be queried in place of the table itself. This secondary index is a data structure that contains a subset of attributes from a table and an alternate key. The benefit of querying an index instead of the main table is skipping a full scan of the main table. This makes the operation much faster.
User Defined Views
The add-in supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .
SSL Configuration
Use SSL Configuration to adjust how add-in handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .
Firewall and Proxy
Configure the add-in for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.
Query Processing
The add-in offloads as much of the SELECT statement processing as possible to Amazon DynamoDB and then processes the rest of the query in memory (client-side).For further information, see Query Processing.