Yandex Cloud
  • Services
  • Solutions
  • Why Yandex Cloud
  • Blog
  • Pricing
  • Documentation
  • Contact us
Get started
Language / Region
Yandex project
© 2023 Yandex.Cloud LLC
Yandex Managed Service for YDB
  • Getting started
  • Step-by-step instructions
    • Overview
    • Database management via the console Yandex Cloud
    • Database management using the YC CLI
    • Connecting to a database using the YDB CLI
    • Managing tables and directories
    • Reading and writing data
    • Monitoring DB status
  • Practical guidelines
    • Deploying a web application
    • Developing a Slack bot
    • Connecting to YDB from Yandex Cloud Functions function in Python
    • Connecting to a YDB database from Yandex Cloud Functions function in Node.js
    • Converting a video to a GIF in Python
    • Developing a skill for Alice and a website with authorization
  • Concepts
    • Overview
    • Terms and definitions
    • Serverless and Dedicated operation modes
    • DynamoDB tables
    • Quotas and limits
  • Access management
  • Pricing policy
    • Overview
    • Serverless mode
      • Pricing policy for serverless mode
      • Request cost for YQL
      • Request cost for the Document API
      • Request cost for special APIs
      • Cost of topic operations
    • Dedicated mode
  • Amazon DynamoDB-compatible Document API
    • Tools
      • Setting up AWS tools
      • Working with data through the HTTP interface
      • Working with the AWS CLI
        • Overview
        • Creating a table
        • Adding data to a table
        • Reading data from a table
        • Updating data
        • Data selections
        • Deleting created resources
      • Working with the AWS SDK
        • Overview
        • Creating a table
        • Uploading data to a table
        • Managing records in a table
          • Creating a record
          • Reading a record
          • Updating a record
          • Deleting a record
        • Searching and extracting data
        • Deleting a table
    • Document API reference
      • All methods
      • Actions
        • BatchGetItem
        • BatchWriteItem
        • CreateTable
        • DeleteItem
        • DeleteTable
        • DescribeTable
        • DescribeTimeToLive
        • GetItem
        • ListTables
        • PutItem
        • Query
        • Scan
        • TransactGetItems
        • TransactWriteItems
        • UpdateItem
        • UpdateTimeToLive
    • Common errors when working with the Document API
  • API Reference Yandex Cloud for Managed Service for YDB
    • Overview
    • Authentication in the API
    • gRPC
      • Overview
      • BackupService
      • DatabaseService
      • LocationService
      • ResourcePresetService
      • StorageTypeService
      • OperationService
    • REST
      • Overview
      • Backup
        • Overview
        • delete
        • get
        • list
        • listPaths
      • Database
        • Overview
        • backup
        • create
        • delete
        • get
        • list
        • move
        • restore
        • start
        • stop
        • update
      • Location
        • Overview
        • get
        • list
      • ResourcePreset
        • Overview
        • get
        • list
      • StorageType
        • Overview
        • get
        • list
  • Questions and answers
  1. Questions and answers

Questions and answers about Managed Service for YDB

Written by
Yandex Cloud
  • Managed Service for YDB databases in Serverless mode
    • Secondary indexes and query cost

This page shows questions and answers about Managed Service for YDB. For frequently asked questions about YDB, see the documentation.

Managed Service for YDB databases in Serverless mode

Secondary indexes and query cost

Operations with indexes are estimated according to the same rules as operations with tables. They are reflected in the request statistics and included in the total indicators that are used to calculate the cost in Request Units (RU). For more information, see the pricing policy for the serverless YDB API.

When reading data from a table using an index, the request statistics will show the number of rows read from the index and their volume.

When adding a new row to a table, a record is also added to each index that exists in this table, with the number of added records and the volume of written data shown in the statistics.

Whenever a table row update occurs, the statistics will reflect a deletion operation for the old record and an insert for the new one for all indexes that include the fields being updated.

When deleting a table row, the statistics will include the deletion of records from all indexes in this table.

Was the article helpful?

Language / Region
Yandex project
© 2023 Yandex.Cloud LLC
In this article:
  • Managed Service for YDB databases in Serverless mode
  • Secondary indexes and query cost