[ignite] branch master updated: IGNITE-17570 Extend documentation about defining of indices (#10211)

[sd...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

sdanilov pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ignite.git


The following commit(s) were added to refs/heads/master by this push:
     new 7e79c2e3f12 IGNITE-17570 Extend documentation about defining of indices (#10211)
7e79c2e3f12 is described below

commit 7e79c2e3f1295bd517866ca5b0e07c3de42b9e44
Author: IgGusev <de...@mail.ru>
AuthorDate: Wed Aug 24 13:48:18 2022 +0400

    IGNITE-17570 Extend documentation about defining of indices (#10211)
---
 docs/_docs/SQL/indexes.adoc | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/docs/_docs/SQL/indexes.adoc b/docs/_docs/SQL/indexes.adoc
index 2f60e79684b..1c5acc7933a 100644
--- a/docs/_docs/SQL/indexes.adoc
+++ b/docs/_docs/SQL/indexes.adoc
@@ -298,13 +298,22 @@ include::{csharpFile}[tag=query-entity-with-inline-size,indent=0]
 tab:C++[unsupported]
 --
 
-* If you create indexes using the `CREATE INDEX` command, you can use the `INLINE_SIZE` option to set the inline size. See examples in the link:sql-reference/ddl[corresponding section].
+* If you create indexes by using the `CREATE INDEX` command, you can use the `INLINE_SIZE` option to set the inline size. See examples in the link:sql-reference/ddl[corresponding section].
 +
 [source, sql]
 ----
 create index country_idx on Person (country) INLINE_SIZE 13;
 ----
 
+* If you create a table by using the `CREATE TABLE` command, you can use the ` PK_INLINE_SIZE` and `AFFINITY_INDEX_INLINE_SIZE` parameters to set primary key and affinity index sizes.
++
+[source, sql]
+----
+CREATE TABLE IF NOT EXISTS TABLE1 (
+  id varchar(15),
+  col varchar(100),
+  PRIMARY KEY(id) ) WITH "PK_INLINE_SIZE=19,AFFINITY_INDEX_INLINE_SIZE=20"
+----
 
 == Custom Keys
 If you use only predefined SQL data types for primary keys, then you do not need to perform additional manipulation with the SQL schema configuration. Those data types are defined by the `GridQueryProcessor.SQL_TYPES` constant, as listed below.