Oracle 23ai のベクトル索引で近傍検索を高速化

![](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/410176/1e36f264-4b63-6009-b8de-78ca179e4f12.png)

[前回の記事](https://qiita.com/ryotayamanaka/items/156932a48e65d3ddc5ac) ではベクトル距離を用いた検索に絞って機能を紹介しましたが、その後、多くの記事で、ベクトルを使った RAG の実装方法がより包括的に紹介されています。

検索の度にベクトル距離を計算して比較しようとすると、ベクトルの数（RAG であれば検索対象の文書から作成されたチャンクの数）やベクトルの次元数に応じて、計算負荷が高くなってしまいます。

そこで、多くのベクトル・データベースは、索引を用いて「近似した」近傍検索を実装しています。Oracle Database 23ai にもそのようなベクトル索引が追加されているため、この記事の前半では使い方を見ておき、後半では近傍検索の高速化を体験してみましょう！

```:ベクトル索引が使用された際の実行計画
----------------------------------------------------------------------------------------------------
| Id  | Operation                      | Name              | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |                   |     3 |    81 |     2  (50)| 00:00:01 |
|*  1 |  COUNT STOPKEY                 |                   |       |       |            |          |
|   2 |   VIEW                         |                   |     3 |    81 |     2  (50)| 00:00:01 |
|*  3 |    SORT ORDER BY STOPKEY       |                   |     3 |   219 |     2  (50)| 00:00:01 |
|   4 |     TABLE ACCESS BY INDEX ROWID| GALAXIES          |     3 |   219 |     1   (0)| 00:00:01 |
|   5 |      VECTOR INDEX HNSW SCAN    | GALAXIES_HNSW_IDX |     3 |   219 |     1   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------
```

## メモリ領域の確保

Oracle Database 23ai は一般的に使われている 2 つのベクトル索引である、Hierarchical Navigable Small World (HNSW) 索引と Inverted File Flat (IVF) 索引を搭載しています。ここでは、特に高速で高精度とされている HNSW 索引を試します。

HNSW 索引はメモリを多く消費するので、Oracle Database 23ai ではメモリ内に [ベクトル・プール](https://docs.oracle.com/cd/G11854_01/vecse/size-vector-pool.html) と呼ばれる領域を確保することで、この索引が利用可能になります。

CDB の初期化パラメータにサイズを設定します。

```sql
ALTER SYSTEM SET vector_memory_size=300M SCOPE=SPFILE;
```

このパラメータの変更には再起動が必要です。

```
shutdown immediate
startup
```

設定されたことを確認します。

```
show parameter vector_memory_size
```
```
NAME               TYPE        VALUE 
------------------ ----------- ----- 
vector_memory_size big integer 304M   
```

## ベクトル索引の作成

前回の記事で作成している [GALAXIES 表](https://qiita.com/ryotayamanaka/items/156932a48e65d3ddc5ac#vector-%E5%9E%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E6%A0%BC%E7%B4%8D) の ENBEDDING 列（VECTOR 型）に対して HNSW 索引を作成します。この際には、ベクトル間の距離の計算方法を指定しておく必要があるため、ここでは COSINE（コサイン距離）とします。この場合、VECTOR_DISTANCE 関数を使って近傍検索を実行する際には、COSINE が指定されたときのみこの索引が使用されます。

```sql
CREATE VECTOR INDEX galaxies_hnsw_idx ON galaxies (embedding)
ORGANIZATION INMEMORY NEIGHBOR GRAPH DISTANCE COSINE;
```

ベクトル索引の詳細は以下のドキュメントを参照してください。

 * [SQL Reference - CREATE VECTOR INDEX](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/create-vector-index.html)
* [AI Vector Search User's Guide - Create Vector Indexes](https://docs.oracle.com/en/database/oracle/oracle-database/23/vecse/create-vector-indexes.html)

## 索引を使わない「完全な」近傍検索

まず、前回紹介した VECTOR_DISTANCE 関数を用いて、銀河「M31」のベクトルにコサイン距離が近いものを 3 つ取得します。

```sql
SELECT name
FROM galaxies
ORDER BY VECTOR_DISTANCE(embedding, '[0.26833928, 0.012467232, -0.48890606, 0.61341953, 0.5590402]', COSINE)
FETCH FIRST 3 ROWS ONLY;
```
```
NAME                                              
--------------------------------------------------
M31
M77
M91
```

実行計画を見てみると、索引は使われておらず、表がフルスキャンされていることがわかります。全ての行（ここでは 9 つの銀河）のベクトルと与えたベクトルの間のコサイン距離を計算して、これをソートしていると考えられます。

```sql
EXPLAIN PLAN FOR
SELECT name
FROM galaxies
ORDER BY VECTOR_DISTANCE(embedding, '[0.26833928, 0.012467232, -0.48890606, 0.61341953, 0.5590402]', COSINE)
FETCH FIRST 3 ROWS ONLY;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
```
```
------------------------------------------------------------------------------------
| Id  | Operation               | Name     | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |          |     3 |    81 |     4  (25)| 00:00:01 |
|*  1 |  COUNT STOPKEY          |          |       |       |            |          |
|   2 |   VIEW                  |          |     9 |   243 |     4  (25)| 00:00:01 |
|*  3 |    SORT ORDER BY STOPKEY|          |     9 |   657 |     4  (25)| 00:00:01 |
|   4 |     TABLE ACCESS FULL   | GALAXIES |     9 |   657 |     3   (0)| 00:00:01 |
------------------------------------------------------------------------------------
```

## 索引を使って「近似された」近傍検索

次に、FETCH 句に APPROX（approximate = 近似する）というキーワードを追加して、近似された近傍検索の結果を取得します。結果は同じ 3 つの銀河が返されています。

```sql
SELECT name
FROM galaxies
ORDER BY VECTOR_DISTANCE(embedding, '[0.26833928, 0.012467232, -0.48890606, 0.61341953, 0.5590402]', COSINE)
FETCH APPROX FIRST 3 ROWS ONLY;
```
```
NAME                                              
--------------------------------------------------
M31
M77
M91
```

実行計画を見てみると、今回は索引が使用されていて、GALAXIES 表の 3 行のみにアクセスしていることがわかります。

```sql
EXPLAIN PLAN FOR
SELECT name
FROM galaxies
ORDER BY VECTOR_DISTANCE(embedding, '[0.26833928, 0.012467232, -0.48890606, 0.61341953, 0.5590402]', COSINE)
FETCH APPROX FIRST 3 ROWS ONLY;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
```
```
----------------------------------------------------------------------------------------------------
| Id  | Operation                      | Name              | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |                   |     3 |    81 |     2  (50)| 00:00:01 |
|*  1 |  COUNT STOPKEY                 |                   |       |       |            |          |
|   2 |   VIEW                         |                   |     3 |    81 |     2  (50)| 00:00:01 |
|*  3 |    SORT ORDER BY STOPKEY       |                   |     3 |   219 |     2  (50)| 00:00:01 |
|   4 |     TABLE ACCESS BY INDEX ROWID| GALAXIES          |     3 |   219 |     1   (0)| 00:00:01 |
|   5 |      VECTOR INDEX HNSW SCAN    | GALAXIES_HNSW_IDX |     3 |   219 |     1   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------
```

このように、近傍検索にベクトル索引が利用されることがわかりました。

## 大きめのデータで実験 （準備）

上のサンプルではデータサイズが小さいため、ベクトル索引による性能向上を感じることができません。そこで、ランダムに抽出した日本語 Wikipedia の文書を用いて、以下のようなデータを作成して実験してみました。

* 検索対象の wiki_ja_10k_embedding 表
    * 元の Wikipedia 文書の数：10,000 
    * 切り出したチャンクの数：25,050（＝表の行数）
    * ベクトルの次元数：1,536
* クエリ
    * 質問「日本の離島について教えて下さい」のベクトル表現
    * ベクトルの次元数：1,536

この実験は、[前回の記事](https://qiita.com/ryotayamanaka/items/156932a48e65d3ddc5ac) で用いた Oracle Database 23ai の無償版 Docker イメージで再現できるので、興味のある方は試してみてください。

sys でログインして myuser にディレクトリ作成の権限を与えます。

```sql:sys
GRANT create any directory, drop any directory TO myuser;
```

OS 上でディレクトリ（ここでは `/dir01`）を作成した後、myuser でデータベース上のディレクトリを作成します。

```sql:myuser
CREATE DIRECTORY dir01 AS '/dir01';
```

wiki_ja_10k_embedding 表のダンプをダウンロードします。


```
cd /dir01
curl -O https://objectstorage.ap-tokyo-1.oraclecloud.com/n/nr92jg8wdcil/b/public/o/wiki_ja_10k_embedding.dmp
```

wiki_ja_10k_embedding 表をインポートします。

```
impdp myuser/password123@freepdb1 \
tables=myuser.wiki_ja_10k_embedding directory=dir01 dumpfile=wiki_ja_10k_embedding.dmp logfile=wiki_ja_10k_embedding.log
```

## 大きめのデータで実験 （結果）

さて、検索対象の表が用意できたので、早速クエリを実行してみましょう。

クエリ結果を日本語で表示したいので、環境変数を設定してから myuser でログインします。

```
export NLS_LANG=JAPANESE_JAPAN.UTF8
sqlplus myuser/password123@freepdb1
```

はじめに、完全近傍検索を実行します。「日本の離島について教えて下さい」という質問が、1,536 次元という大きなベクトルになっているので、これをクエリに含めるために、いくつかに分割して TO_CLOB 関数を使いながら再度結合する、といったことをしています。実際のアプリケーションではベクトル型のバインド変数が使われます。

今回は FETCH 句に **EXACT** を指定しています。このキーワードは有無に関わらず（ベクトル索引がない場合には APPROX が指定されていても）完全近傍検索が実行されますが、このように明示的に指定しておいてもわかりやすいです。

```sql
SET TIMING ON
SELECT JSON_VALUE(metadata, '$.title') title, 
       SUBSTR(text, 0, 100) text
FROM wiki_ja_10k_embedding
ORDER BY VECTOR_DISTANCE(
  embedding
, TO_CLOB('[-0.01994413696229458, -0.03181380406022072, 0.01651684381067753, 0.07892456650733948, 0.02344888262450695, -0.010678826831281185, -0.04937626048922539, 0.01399962231516838, 0.05630830302834511, 0.02098975144326687, 0.010669144801795483, 0.04999588429927826, -0.028192877769470215, -0.010891822166740894, -0.0027205352671444416, -0.042328041046857834, -0.012634513899683952, 0.01235374715179205, 0.05781863257288933, 0.04046916961669922, 0.004412398207932711, -0.021009115502238274, 0.006646431982517242, -0.0021940970327705145, 0.02875441126525402, -0.03047773987054825, 0.06180746108293533, 0.012779738754034042, 0.004627814516425133, -0.012489289976656437, 0.038726478815078735, -0.03235597535967827, 0.04205695539712906, -0.039055656641721725, -0.02449449896812439, 0.029780663549900055, 0.045116350054740906, -0.03330477327108383, -0.02720535174012184, -0.051932208240032196, 0.02453322522342205, -0.012072980403900146, 0.027786249294877052, -0.017620548605918884, -0.03946228325366974, 0.06145892292261124, -0.043412383645772934, 0.00769204692915082, -0.005344254430383444, 0.011230679228901863, -0.0028221921529620886, 0.030361559242010117, -0.021435106173157692, -0.06374378502368927, -0.051235131919384, -0.01868552714586258, -0.002730216830968857, 0.05599848926067352, 0.012963688932359219, -0.01929546892642975, 0.035725176334381104, -0.019034065306186676, -0.023603789508342743, 0.06684190034866333, 0.04736248403787613, 0.004349467810243368, 0.016255440190434456, 0.022538810968399048, -0.06103293225169182, 0.020912298932671547, 0.03179444000124931, -0.002781045390293002, 0.005634702742099762, -0.008742502890527248, -0.01692347228527069, -0.0026503433473408222, -0.017523732036352158, -0.010640100575983524, -0.019673051312565804, 0.012072980403900146, -0.008200332522392273, 0.06986256688833237, -0.031871892511844635, -0.0031416856218129396, 0.06873950362205505, 0.03243342787027359, -0.005915469955652952, 0.05286164581775665, 0.01969241537153721, -0.046045783907175064, -0.04534870758652687, 0.0014098859392106533, -0.08062852919101715, 0.07888583838939667, -0.03134908527135849, -0.029141675680875778, -0.005092531908303499, 0.027902428060770035, 0.013370317406952381, -0.04902772232890129, -0.021919187158346176, -0.06343397498130798, -0.0067190444096922874, 0.02315843477845192, 0.014580519869923592, -0.01381567120552063, -0.023932963609695435, 0.02550138719379902, -0.06827478110790253, 0.022519448772072792, 0.00022887955128680915, -0.0023453724570572376, -0.012131069786846638, 0.07261215150356293, 0.009008747525513172, 0.04267657920718193, 0.050847869366407394, -0.025714382529258728, 0.06525412201881409, -0.03185252845287323, -0.02524966560304165, 0.01360267587006092, 0.054565608501434326, 0.024726856499910355, 0.004741573240607977, -0.02048630826175213, 0.008989384397864342, 0.035473454743623734, -0.004160676151514053, 0.025966104120016098, 0.035260461270809174, -0.04480653628706932, -0.03589944541454315, -0.012808782979846, 0.015577726066112518, 0.06107166036963463, 0.004678642842918634, 0.004349467810243368, -0.030787551775574684, 0.011947118677198887, 0.052513107657432556, 0.008084152825176716, 0.03229788318276405, -0.025520749390125275, 0.01821112632751465, -0.0035846198443323374, -0.006157510448247194, 0.014909694902598858, 0.010736916214227676, -0.014454658143222332, 0.011153225786983967, -0.025772472843527794, 0.022519448772072792, -0.02478494681417942, -0.05382980778813362, 0.034931283444166183, 0.017407553270459175, -0.03256896883249283, -0.012450562790036201, 0.04484526440501213, 0.009352444671094418, 0.006578660570085049, -0.00941537506878376, 0.01120163407176733, -0.004301059525460005, -0.04267657920718193, 0.02947085164487362, 0.01753341406583786, -0.036673977971076965, -0.003766150213778019, -0.017862588167190552, -0.021919187158346176, 0.04070153087377548, 0.003127163276076317, -0.014270707964897156, -0.02186109870672226, 0.03988827392458916, -0.045658521354198456, -0.010882141068577766, 0.06416977941989899, -0.0085488706827163')
||TO_CLOB('7, -0.023971691727638245, -0.09720346331596375, -0.004213924985378981, 0.013951214030385017, -0.03828112408518791, -0.007866316474974155, -0.00781306717544794, 0.020505670458078384, 0.0038411826826632023, 0.009565440937876701, -0.009700982831418514, 0.019847320392727852, -0.00799217727035284, -0.008669890463352203, 0.007135353982448578, -0.025985468178987503, -0.01556804496794939, 0.04887281730771065, -0.044457998126745224, 0.01918897032737732, -0.04643305018544197, 0.005746041424572468, 0.016894426196813583, -0.006418914068490267, 0.011230679228901863, -0.021222110837697983, -0.011492082849144936, 0.04302511736750603, -0.011830939911305904, 0.0006843695300631225, -0.002054923912510276, -0.007590389810502529, 0.024765584617853165, -0.0032820692285895348, -0.011240360327064991, 0.03758404776453972, -0.004204243421554565, -0.08907090127468109, -0.026256553828716278, 0.014628928154706955, -0.025462660938501358, 0.003378885332494974, -0.015955310314893723, -0.033420950174331665, 0.020370127633213997, 0.04105006903409958, 0.020931662991642952, 0.07350286096334457, 0.028057334944605827, 0.02428150363266468, 0.03150399029254913, -0.02337143011391163, -0.0308456402271986, 0.01767863892018795, -0.00021299564104992896, -0.012237567454576492, -0.037312962114810944, -0.019072791561484337, -0.011501764878630638, 0.021125294268131256, -0.013070186600089073, 0.0125376982614398, 0.01396089605987072, 0.045038897544145584, -0.03959782421588898, 0.001117016887292266, -0.019576234742999077, 0.04062407836318016, 0.018666163086891174, 0.03657716140151024, -0.023429520428180695, 0.042444221675395966, -0.044535450637340546, -0.04155351221561432, -0.006452799774706364, -0.0012011260259896517, 0.0267019085586071, 0.002068236004561186, 0.0151517353951931, 0.02842523530125618, 0.03163953498005867, -0.02027331292629242, -0.057741180062294006, -0.0015236448962241411, 0.007004652172327042, 0.00397672550752759, -0.0247074943035841, -0.0056201801635324955, -0.017485005781054497, 0.019392285495996475, -0.07346413284540176, -0.022422632202506065, -0.03202679753303528, -0.017223602160811424, 0.0029432123992592096, -0.05057678371667862, -0.051893483847379684, -0.02846396341919899, -0.04426436498761177, -0.0436447411775589, -0.014919376000761986, -0.010833732783794403, -0.00775497779250145, -0.009599326178431511, 0.012808782979846, -0.00709662726148963, -0.019256742671132088, -0.014706380665302277, 0.0067626116797327995, 0.0865924060344696, -0.024843037128448486, -0.02089293673634529, -0.026256553828716278, 0.008640846237540245, -0.030148563906550407, 0.029877478256821632, -0.021009115502238274, 0.013389680534601212, 0.026062920689582825, -0.018917884677648544, -0.01843380369246006, 0.02098975144326687, -0.016361936926841736, 0.0006680318037979305, 0.001613199943676591, -0.02875441126525402, -0.021164020523428917, 0.026759997010231018, 0.014125483110547066, 0.0007654530927538872, -0.036015626043081284, -0.020505670458078384, 0.022751806303858757, 0.0008931294432841241, -0.05382980778813362, -0.01587785594165325, 0.007914723828434944, 0.0015563203487545252, 0.01994413696229458, 0.00309327756986022, 0.03936546668410301, 0.006815860513597727, 0.00034763067378662527, -0.0703660100698471, 0.0024676029570400715, -0.024688130244612694, -0.029703209176659584, -0.027766885235905647, 0.029354671016335487, -0.039810821413993835, -0.014532111585140228, 0.06688062846660614, -0.007261214777827263, -0.02373933233320713, 0.007479051593691111, -0.044729083776474, 0.052435655146837234, -0.058167170733213425, 0.00709662726148963, -0.009008747525513172, -0.017194556072354317, 0.007450006436556578, 0.04956989362835884, -0.008084152825176716, 0.021086568012833595, 0.043373655527830124, -0.001032907865010202, -0.006820701062679291, -0.016545888036489487, -0.003746786853298545, 0.009638052433729172, 0.02428150363266468, -0.039694640785455704, 0.0167782474309206, -0.02441704459488392, 0.04809828847646713, -0.030748825520277023, -0.02428150363266468, 0.023565063253045082, -0.06684190034866')
||TO_CLOB('333, -0.053984712809324265, -0.010417423211038113, 0.06056821346282959, 0.009933342225849628, 0.01673952117562294, -0.042328041046857834, -0.03005174733698368, 0.018520938232541084, -0.003236081451177597, 0.021725555881857872, -0.007527459412813187, -0.05108022689819336, -0.007880838587880135, 0.02683744952082634, -0.032956235110759735, -0.0060461717657744884, -0.03506682813167572, 0.014018985442817211, 0.017794817686080933, -0.003635448170825839, 0.0171364676207304, -0.024475134909152985, 0.013341272249817848, -0.002461551921442151, 0.02583056129515171, 0.05692792683839798, -0.036054354161024094, 0.0239910539239645, 0.05530141294002533, 0.016110215336084366, 0.02395232766866684, 0.04534870758652687, 0.030942456796765327, 0.00035943015245720744, -0.018559664487838745, 0.0003878698917105794, 0.027786249294877052, -0.029393397271633148, 0.03344031423330307, -0.003809717483818531, -0.029490213841199875, -0.016323210671544075, 0.02799924463033676, 0.03272387385368347, 0.01648779958486557, -0.023623151704669, -0.04484526440501213, -0.022209636867046356, -0.002145688980817795, 0.002045242115855217, -0.061923641711473465, 0.03125226870179176, -0.019053427502512932, -0.005736359860748053, 0.028367146849632263, 0.018375715240836143, 0.02178364433348179, 0.026934266090393066, -0.08124815672636032, -0.002638241508975625, 0.029141675680875778, -0.03481510654091835, -0.009628371335566044, 0.04221186414361, 0.009284673258662224, 0.00852950755506754, 0.0006408022018149495, 0.0393267385661602, -0.035260461270809174, 0.025269027799367905, 0.00590578792616725, -0.037099968641996384, 0.029606394469738007, 0.028560778126120567, 0.017881952226161957, -0.011143544688820839, -0.001092812861315906, 0.009933342225849628, 0.003589460626244545, 0.039229925721883774, -0.05654066056013107, -0.01421261765062809, 0.020137770101428032, 0.04790465533733368, -0.010601373389363289, 0.04426436498761177, 0.03961718827486038, -0.028870590031147003, 0.0052958461456000805, 0.021686827763915062, -0.030361559242010117, 0.02240326814353466, 0.019276104867458344, 0.06560266017913818, 0.020331401377916336, -0.0364416167140007, -0.0027423189021646976, 0.015219506807625294, 0.006278530694544315, 0.0030400287359952927, 0.04902772232890129, -0.019750503823161125, -0.019063109531998634, -0.005082850344479084, -0.0151517353951931, -0.010078566148877144, 0.05526268482208252, -0.023274613544344902, 0.025385206565260887, -0.01517109852284193, 0.004874695558100939, -0.02337143011391163, -0.046123236417770386, -0.10231535881757736, 0.028851227834820747, -0.05425579845905304, -0.01582944765686989, -0.018307942897081375, -0.014406250789761543, -0.02608228474855423, 0.011172589845955372, 0.011947118677198887, 0.013873761519789696, 0.0009433528175577521, 0.024262139573693275, 0.019498782232403755, 0.029412761330604553, -0.05623084679245949, 0.02615973725914955, -0.031077999621629715, 0.028522051870822906, 0.04902772232890129, -0.003533791285008192, 0.030206654220819473, 0.003136844839900732, -0.03369203582406044, -0.007866316474974155, 0.0010087037226185203, 0.025423934683203697, -0.023061618208885193, -0.031116725876927376, -0.015887537971138954, 0.004652018193155527, -0.047168850898742676, -0.028657594695687294, -0.011017683893442154, -0.006259167101234198, 0.009047473780810833, 0.04356728866696358, -0.011724441312253475, 0.010920867323875427, -0.03289814293384552, -0.010659463703632355, 0.0007660581613890827, 0.0016749202040955424, -0.017184875905513763, 0.002638241508975625, -0.03578326851129532, -0.031116725876927376, -0.014048030599951744, 0.015209824778139591, 0.01702028699219227, -0.02972257323563099, 0.03595753759145737, 0.039810821413993835, -0.03262706100940704, 0.00160109787248075, 0.010707871988415718, 0.037603411823511124, -0.04840809851884842, -0.014135165140032768, -0.011095136404037476, 0.04430309310555458, 0.03940419480204582, -0.01918897032737732, 0.005010238382965326, -0.012508653104305267, 0.010707871988415718, 0.017475323751568794, 0.014503066428005695, 0.03719678')
||TO_CLOB('521156311, -0.010001113638281822, -0.012189159169793129, -0.04891154542565346, -0.02972257323563099, 0.020951025187969208, -0.026450185105204582, -0.025385206565260887, -0.022829260677099228, -0.008345556445419788, -0.023061618208885193, -0.03618989512324333, -0.015480910427868366, -0.010020476765930653, 0.012334384024143219, -0.009584804065525532, -0.0207380298525095, 0.013283182866871357, -0.0004332524840719998, -0.0004456570604816079, 0.02799924463033676, -0.01951814629137516, 0.02089293673634529, -0.0036427094601094723, -0.012760374695062637, -0.021706191822886467, -0.030613282695412636, 0.0028706002049148083, 2.8799036954296753e-05, 0.011153225786983967, -0.03324668109416962, -0.03038092330098152, 0.03332413733005524, -0.026972992345690727, 0.0012035464169457555, 0.012653877027332783, -0.014057711698114872, 0.022306451573967934, -0.012973370961844921, -0.007924405857920647, 0.011463037692010403, -0.021377017721533775, -0.011075773276388645, -0.02637273259460926, -0.014967784285545349, 0.02432022988796234, -0.00957996305078268, -0.004429341293871403, 0.019237378612160683, -0.024436408653855324, -0.0005076799425296485, 0.02712789922952652, 0.023971691727638245, -0.009734869003295898, -0.03235597535967827, 0.03833921626210213, 0.028115423396229744, -0.017049333080649376, -0.006752930115908384, 0.002166262362152338, 0.011337176896631718, 0.002519641537219286, -0.0031392653472721577, 0.00898454338312149, -0.03080691397190094, 0.010911185294389725, -0.03694505989551544, 0.023816784843802452, -0.010059203021228313, -0.01709774136543274, 0.006738407537341118, 0.0057412004098296165, 0.013196048326790333, 0.04530997946858406, -0.02997429482638836, 0.01414484716951847, 0.04542616009712219, -0.01908247359097004, 0.018714571371674538, 0.00620591826736927, -0.004734312184154987, 0.04174714535474777, 0.060878027230501175, -0.0024881763383746147, 0.009788117371499538, -0.009386330842971802, -0.012741011567413807, -0.010078566148877144, -0.030671371147036552, -0.0063705057837069035, 0.0059687187895178795, -0.01666206866502762, 0.011550172232091427, 0.0020912298932671547, 0.001656767213717103, -0.00917817559093237, 0.02428150363266468, -0.009110404178500175, 0.015345367603003979, 0.0017923099221661687, -0.039694640785455704, 0.004828707780689001, -0.016061807051301003, 7.819042366463691e-06, 0.020137770101428032, -0.010059203021228313, 0.041863325983285904, -0.006317256949841976, -0.017920678481459618, -0.010214108973741531, -0.01594562828540802, -0.03874584287405014, -0.03917183354496956, 0.02846396341919899, 0.03324668109416962, 0.02954830415546894, 0.017049333080649376, -0.00466170022264123, -0.016400665044784546, -0.012043935246765614, 0.037680864334106445, -0.013089549727737904, 0.0017184875905513763, 0.01580040343105793, -0.03841666877269745, 0.011821257881820202, 0.007217647507786751, 0.03959782421588898, 0.003478121943771839, 0.025985468178987503, 0.02135765366256237, 0.0017366405809298158, -0.01396089605987072, 0.01437720563262701, 0.007145035546272993, 0.020040953531861305, -0.023932963609695435, -0.006990129593759775, -0.03001302108168602, -0.0008205173071473837, 0.04465163126587868, 0.012866873294115067, -0.002243715338408947, -0.033169228583574295, -0.01821112632751465, -0.013050823472440243, -0.007900201715528965, -0.012818465009331703, -0.038513485342264175, -0.04705267399549484, -0.0024881763383746147, 0.009173334576189518, -0.016758883371949196, -0.004422079771757126, -0.001845558756031096, 0.038939476013183594, -0.002054923912510276, -0.0012900758301839232, 0.06254326552152634, -0.01433847937732935, -0.01356394961476326, -0.01835635118186474, -0.0085682338103652, -0.0063705057837069035, -0.00957512203603983, -0.039733368903398514, -0.020428217947483063, 0.03466019779443741, -0.02373933233320713, 0.017523732036352158, -0.0073628718964755535, -0.006278530694544315, 0.00042992443195544183, -0.006433436647057533, -0.009584804065525532, 0.012498971074819565, -0.0038823296781629324, -0.010978956706821918, 0.006772293243557215, ')
||TO_CLOB('-0.008815115317702293, 0.019053427502512932, 0.009444420225918293, 0.014861286617815495, 0.024126596748828888, -0.04732375964522362, -0.05657938867807388, 0.000339764344971627, 0.008374601602554321, -0.00590578792616725, -0.018414441496133804, -0.002660025143995881, 0.016691112890839577, 0.029606394469738007, 0.0026455025654286146, 0.027031082659959793, -0.04631686955690384, -0.01824985444545746, 0.0038605460431426764, -0.04197950288653374, -0.0018588710809126496, 0.0125376982614398, 0.04794338345527649, -0.011966481804847717, 0.007861475460231304, 0.0007836061413399875, -0.0011611892841756344, 0.006176873575896025, 0.0074838921427726746, -0.012431199662387371, 0.006259167101234198, 0.001208387198857963, -0.024804310873150826, -0.014522429555654526, 0.023565063253045082, -0.007266055792570114, 0.004378512501716614, -0.013079868629574776, 0.011927755549550056, -0.023352067917585373, 0.013312227092683315, 0.028309056535363197, 0.00012570979015436023, 0.030361559242010117, 0.009521872736513615, -0.01799813099205494, -0.05534014105796814, -0.016061807051301003, 0.0013711594510823488, -0.005063487216830254, -0.030652008950710297, -0.029877478256821632, -0.007750136777758598, 0.04217313602566719, 0.0023719968739897013, -0.015742313116788864, -0.017078377306461334, -0.004499532748013735, -0.023139070719480515, 0.013738218694925308, -0.0216481015086174, -0.006273689679801464, 0.012382792308926582, 0.008137401193380356, -0.016390983015298843, -0.01728169247508049, 0.017223602160811424, -0.001148482202552259, -0.0058961063623428345, -0.026256553828716278, -0.008849000558257103, -0.014125483110547066, -0.029161039739847183, 0.018240172415971756, 0.00878122914582491, 0.01732041873037815, -0.028405873104929924, -0.02683744952082634, -0.06006477028131485, 0.008868363685905933, -0.00399608863517642, -0.012595787644386292, 0.00769204692915082, -0.028638232499361038, -0.003855705028399825, 0.023894237354397774, -0.024901125580072403, 0.010310925543308258, -0.051970936357975006, 0.01435784250497818, -0.01591658405959606, 0.019508464261889458, -0.03285941854119301, -0.006041330751031637, 0.030671371147036552, 0.05104149878025055, 0.01255706138908863, -0.0062882122583687305, 0.012818465009331703, -0.024726856499910355, 0.05731518939137459, -0.0006389869377017021, 0.0019919932819902897, 0.0009754232014529407, -0.017262328416109085, -0.026895539835095406, 0.025385206565260887, -0.011085454374551773, -0.002994040958583355, 0.009153971448540688, -0.01868552714586258, -0.000645643041934818, -0.00016625157149974257, -0.01013665646314621, 0.03874584287405014, -0.014454658143222332, -0.03628671169281006, -0.002827032934874296, 0.03163953498005867, -0.040740255266427994, -0.0026358210016041994, 0.009981750510632992, -0.03481510654091835, 0.02792179211974144, -0.02402978017926216, -0.00037425511982291937, -0.008166446350514889, 0.05073168873786926, 0.04318002611398697, -0.0490664504468441, -0.0382423996925354, 0.009313718415796757, 0.026469549164175987, 0.007938927970826626, 0.021086568012833595, 0.07114054262638092, 0.017078377306461334, 0.003514427924528718, 0.026062920689582825, -0.009705823846161366, 0.013496178202331066, -0.02193855121731758, -0.019789231941103935, 0.054526884108781815, -0.026237189769744873, -0.01854030229151249, 0.022713080048561096, -0.004693165421485901, -0.05475924164056778, -0.02695363014936447, 0.023100344464182854, 0.012886236421763897, 0.0010474302107468247, -0.001958107575774193, 0.010310925543308258, 0.046045783907175064, -0.006772293243557215, -0.04000445455312729, -0.03233661130070686, 0.0064140730537474155, 0.05108022689819336, -0.01536473073065281, 0.012682922184467316, -0.03402121365070343, 0.021686827763915062, -0.02207409404218197, -0.012731330469250679, -0.002218301175162196, 0.01433847937732935, -0.002427666215226054, -0.01159858051687479, -0.010214108973741531, -0.011046728119254112, -0.02445577271282673, 0.041398607194423676, -0.022751806303858757, -0.005257119424641132, -0.0055717723444104195, 0.0609167516231536')
||TO_CLOB('87, -0.025443296879529953, -0.017039651051163673, 0.017901314422488213, -0.000878001912496984, 0.004477749112993479, -0.0019399545853957534, -0.002529323101043701, 0.03332413733005524, 0.032123614102602005, 0.009337922558188438, -0.021667465567588806, 0.02035076543688774, -0.007450006436556578, 0.0068400646559894085, -0.0062688491307199, 0.02980002574622631, 0.0250753965228796, -0.00862148217856884, 0.0037080603651702404, 0.027689432725310326, 0.009865570813417435, -0.0028657594230026007, 0.039559099823236465, 0.02641145884990692, -0.045542340725660324, 0.0010649781906977296, 0.010882141068577766, -0.03022601827979088, 0.04108879342675209, -0.011966481804847717, -0.0015526898205280304, 0.009700982831418514, 0.02879313752055168, -0.00011096044181613252, 0.019498782232403755, 0.016255440190434456, 0.028522051870822906, -0.03272387385368347, -0.018927566707134247, -0.03921056166291237, 0.028812501579523087, 0.051312584429979324, -0.0328400544822216, -0.03148462623357773, 0.021803008392453194, 0.005634702742099762, -0.013031460344791412, 0.004388194065541029, -0.0016386142233386636, 0.003935578279197216, -0.000111792454845272, 0.009671938605606556, 0.03557027131319046, 0.024300865828990936, 0.03477637842297554, -0.006230122409760952, 0.03984954580664635, 0.04043044522404671, 0.002882702276110649, 0.008045426569879055, -0.005746041424572468, 0.008853841572999954, 0.04895026981830597, 0.015161416493356228, 0.010097929276525974, -0.011753486469388008, -0.005954196210950613, 0.00379761541262269, -0.032665785402059555, 0.021202746778726578, 0.03088436834514141, -0.003700799308717251, 0.03305305168032646, -0.009822003543376923, 0.04372219741344452, 0.0046447571367025375, -0.03227851912379265, 0.027282804250717163, 0.05793481320142746, -0.004051757976412773, -0.020583124831318855, -0.009555758908390999, 0.04623941704630852, -0.034466568380594254, 0.00477061839774251, 0.0007521408260799944, -0.002761682029813528, 0.021086568012833595, 0.018462849780917168, 0.0022727602627128363, 0.02983875200152397, 0.014657972380518913, -0.015442184172570705, -0.008611801080405712, -0.005470115225762129, -0.00961384829133749, -0.005716996733099222, 0.01421261765062809, 0.006544774863868952, 0.004925524350255728, 0.01857902854681015, -0.013718855567276478, 0.023758694529533386, 0.00997206848114729, -0.02344888262450695, -0.019469738006591797, 0.06126528978347778, -0.02102847769856453, 0.005136099178344011, 0.003613664535805583, 0.042328041046857834, -0.02947085164487362, 0.027360258623957634, -0.021493196487426758, 0.010272198356688023, -0.007905042730271816, -0.0029432123992592096, -0.02131892740726471, 0.012653877027332783, -0.021803008392453194, -0.010465831495821476, 0.011433993466198444, -0.014415931887924671, 0.0008773967856541276, -0.009308877401053905, -0.0082100136205554, 0.002065815730020404, 0.0005061671836301684, -0.026140373200178146, 0.03235597535967827, 0.002851237077265978, -0.022461358457803726, 0.010146337561309338, -0.025656292214989662, -0.015393775887787342, 0.031194180250167847, 0.019827958196401596, -0.02337143011391163, 0.012731330469250679, -0.019053427502512932, -0.0026672862004488707, 0.010959593579173088, -0.005504000931978226, 0.01598435454070568, -0.021105932071805, 0.032375335693359375, 0.043528564274311066, -0.0008568233461119235, 0.0068981540389359, -0.021415743976831436, -0.011230679228901863, -0.052474379539489746, -0.004676222335547209, 0.013922169804573059, 0.03384694457054138, 0.017146149650216103, 0.04910517483949661, -0.006278530694544315, 0.020621851086616516, -0.02550138719379902, -0.01255706138908863, -0.027611980214715004, -0.002638241508975625, 0.01536473073065281, -0.018966292962431908, 0.010252835229039192, -0.0125376982614398, -0.008907089941203594, 0.011211316101253033, 0.027476437389850616, 0.010698189958930016, 0.013728536665439606, 0.03779704496264458, -0.004429341293871403, -0.014870968647301197, -0.021415743976831436, -0.06273689866065979, 0.023603789508342743, -0.009531554765999317, -0.003366783261299')
||TO_CLOB('1333, 0.01644907146692276, 0.006869109347462654, 0.006990129593759775, -0.027786249294877052, 0.03665461391210556, 0.010814369656145573, 0.018666163086891174, -0.005320050287991762, -0.010301243513822556, -0.011869666166603565, 0.02662445418536663, -0.001976260682567954, 0.003800035919994116, -0.009913979098200798, -0.007411280181258917, -0.0111822709441185, 0.023797422647476196, 0.03988827392458916, 0.0012610310222953558, -0.02009904384613037, -0.005867061670869589, -0.010146337561309338, -0.04678158834576607, 0.02139637991786003, 0.049879707396030426, 0.009313718415796757, 0.048137012869119644, 0.0155099555850029, 0.007280578371137381, 0.02879313752055168, 0.01237311027944088, 0.010097929276525974, 0.002836714731529355, -0.008916771970689297, 0.0069659254513680935, -0.0030884367879480124, -0.0033837261144071817, 0.027050446718931198, -0.027766885235905647, -0.025520749390125275, -0.008118038065731525, 0.015277596190571785, -0.023022891953587532, 0.007508096285164356, 0.007967973127961159, -0.01122099719941616, -0.022887349128723145, -0.00041267904452979565, -0.03274323791265488, 0.013157321140170097, -0.02918040193617344, -0.02524966560304165, -0.02929658256471157, 0.002461551921442151, -0.023352067917585373, -0.00899906549602747, -0.0017160670831799507, 0.010417423211038113, -0.006941721308976412, -0.042405493557453156, 0.01644907146692276, -0.0335371308028698, 0.016061807051301003, -0.04728503152728081, 0.0160521250218153, -0.02511412277817726, 0.03357585892081261, 0.03938483074307442, 0.02244199439883232, 0.02377805858850479, -0.011104818433523178, -0.018598392605781555, 0.010736916214227676, 0.0020065156277269125, -0.012450562790036201, 0.002616457873955369, -0.0068981540389359, 0.04786592721939087, -0.011211316101253033, 0.0055427271872758865, 0.05704410374164581, -0.022132182493805885, -0.011211316101253033, -0.02708917297422886, 0.001811673166230321, -0.015674542635679245, -0.026934266090393066, 0.03909438103437424, 0.020466944202780724, -0.03539600223302841, -0.023255251348018646, 0.009003906510770321, -0.01017538271844387, -0.002476074267178774, 0.043993279337882996, -0.0008047846495173872, 0.02348761074244976, -0.007730773650109768, -0.0038702276069670916, 0.03804876655340195, 0.0027665228117257357, 0.006075216457247734, 0.003100538859143853, 0.011908392421901226, 0.03477637842297554, -0.02838650904595852, -0.000353379116859287, 0.011850303038954735, -0.004129210952669382, -0.010959593579173088, -0.01979891210794449, 0.021686827763915062, -0.011250042356550694, 0.012992734089493752, -0.010243154130876064, 0.015538999810814857, -0.007566186133772135, 0.024765584617853165, -0.017698001116514206, -0.01619734987616539, 0.010039839893579483, 0.00478998152539134, 0.005334572400897741, -0.04488398879766464, -0.016497479751706123, 0.004581826739013195, 0.011569535359740257, 0.007343508768826723, -0.014231981709599495, -2.0422166926437058e-05, 0.039559099823236465, -0.00309327756986022, 0.007382235024124384, 0.008887726813554764, -0.017465641722083092, -0.0025777313858270645, 0.02106720581650734, 0.03574454039335251, 0.011153225786983967, -0.009463783353567123, -0.013070186600089073, 0.018278898671269417, 0.008093833923339844, 0.02828969433903694, -0.03444720432162285, -0.026140373200178146, -0.005305527709424496, -0.07001747190952301, 0.0033522609155625105, -0.030826278030872345, 0.010117292404174805, 0.013757581822574139, 0.003006143029779196, 0.01832730695605278, -0.0357058160007, -0.03359522297978401, 0.03287878260016441, -0.011569535359740257, -0.040856435894966125, -0.011540491133928299, -0.0076387980952858925, -0.032917506992816925, 0.011753486469388008, -0.005073168780654669, -0.015538999810814857, 0.006317256949841976, -0.011627625674009323, 0.01341872476041317, -0.008088993839919567, -0.019721459597349167, -0.046161964535713196, 0.04217313602566719, 0.02997429482638836, -0.004163096658885479, -0.02366187982261181, -0.0034369751811027527, 0.024630041792988777, 0.015926264226436615, 0.0022231419570744038, -0.0116469')
||TO_CLOB('88801658154, 0.006932039745151997, -0.02983875200152397, 0.021338289603590965, 0.006191396154463291, -0.008118038065731525, -0.026682544499635696, 0.015645498409867287, 0.0267019085586071, -0.00956059992313385, -0.007803385611623526, 0.010853095911443233, -0.009696142747998238, -0.020796120166778564, 0.00400334969162941, -0.004209084436297417, 0.0028706002049148083, 0.009734869003295898, 0.004378512501716614, 0.015674542635679245, 0.029025496914982796, 0.004540679976344109, 0.0007200705003924668, -0.0070433784276247025, 0.041359879076480865, 0.029664482921361923, 0.004608450923115015, 0.02550138719379902, 0.005058646202087402, -0.001401414512656629, 0.028115423396229744, 0.013951214030385017, 0.017000924795866013, 0.03314986824989319, 0.01872425340116024, -0.030865004286170006, -0.005581453908234835, 0.014929058030247688, 0.007725932635366917, 0.018956610932946205, -0.008902249857783318, -0.040740255266427994, 0.005784767679870129, -0.01706869527697563, -0.008239058777689934, -0.0026091965846717358, 0.05425579845905304, -0.036383528262376785, 0.025849925354123116, -0.00038060868973843753, -0.004293798469007015, -0.03361458331346512, -0.014057711698114872, 0.014270707964897156, -0.024610677734017372, 0.0005185717600397766, 0.022829260677099228, -0.03595753759145737, 0.03729360178112984, -0.02737962082028389, 0.024378318339586258, 0.029432125389575958, 0.006738407537341118, 0.03777768090367317, 0.006118783727288246, -0.008297148160636425, 0.0012186738895252347, -0.029606394469738007, 0.021047841757535934, -0.02821223996579647, -0.03466019779443741, 0.01094991248100996, 0.0005215972778387368, -0.03369203582406044, -0.0013203308917582035, 0.008456895127892494, 0.015374412760138512, -0.00340066896751523, -0.010330288670957088, -0.0026987516321241856, -0.026488911360502243, 0.013660766184329987, -0.024358956143260002, -0.00862148217856884, 0.0018963873153552413, 0.00519418902695179, -0.0027786248829215765, 0.021764282137155533, -0.0026914903428405523, 0.035008735954761505, -0.029993658885359764, -0.0021819951944053173, 0.005087691359221935, -0.014638609252870083, 0.009623530320823193, -0.02590801566839218, -0.012431199662387371, -0.01832730695605278, 0.011511445976793766, -0.0007134143961593509, 0.00407838262617588, -0.023003529757261276, -0.014222299680113792, -0.04019808769226074, -0.02139637991786003, 0.035550907254219055, -0.028367146849632263, -0.020834846422076225, 0.01475478895008564, -0.02048630826175213, -0.013157321140170097, -0.003313534427434206, -0.059290241450071335, 0.0003061812312807888, -0.01096927560865879, 0.010678826831281185, 0.021803008392453194, -0.049724798649549484, -0.02031203918159008, -0.005794449709355831, 0.020505670458078384, 0.044457998126745224, -0.017765773460268974, -0.007880838587880135, 9.530344686936587e-05, 0.031116725876927376, -0.0011841831728816032, 0.03378885239362717, 0.03328540921211243, 0.011859984137117863, 0.0007708990015089512, -0.01093054935336113, -0.02950957790017128, -0.010746598243713379, -0.007425802294164896, -0.0007557714707218111, 0.0003697168722283095, 0.006157510448247194, -0.01821112632751465, 0.02395232766866684, -0.003226399887353182, 0.0001266930776182562, -0.020079679787158966, 0.008713457733392715, 0.0028657594230026007, 0.00999143160879612, -0.008897408843040466, 0.011414630338549614, -0.0015696326736360788, -0.004429341293871403, -0.04228931665420532, 0.0019387444481253624, -0.00011421286035329103, 0.010243154130876064, -0.01652652584016323, -0.05545631796121597, -0.022538810968399048, 0.004627814516425133, -0.018811387941241264, 0.006956243887543678, -0.02265498973429203, -0.020505670458078384, -0.03177507594227791, 0.04484526440501213, 0.014948421157896519, -0.0023235888220369816, 0.009797799400985241, 0.029432125389575958, -0.006051012314856052, -0.005838016979396343, 0.003877488896250725, 0.003775831777602434, 0.02294543944299221, -0.02662445418536663, 0.015577726066112518, -0.007145035546272993, 0.03314986824989319, 0.004095325246453285, -0.003654811531305313, ')
||TO_CLOB('0.025404570624232292, 0.004724630620330572, -0.004356728866696358, -0.015703586861491203, 0.029935568571090698, -0.005779927130788565, -0.015316322445869446, -0.012072980403900146, 0.017146149650216103, -0.012344065122306347, -0.011443674564361572, -0.016933152452111244, 0.0041267904452979565, 0.014444977045059204, 0.031910620629787445, -0.005828335415571928, -0.01237311027944088, -0.036809518933296204, -0.016255440190434456, -0.009749391116201878, -0.0007963132229633629, 0.026179099455475807, 0.043954554945230484, 0.023390794172883034, -0.02575310878455639, -0.03148462623357773, 0.0022473460994660854, -0.011250042356550694, 0.028948044404387474, 0.027805613353848457, 0.026217827573418617, 0.006694840267300606, 0.0026648659259080887, -0.02135765366256237, 0.10161828249692917, -0.02708917297422886, -0.014599882997572422, -0.02207409404218197, 0.010591692291200161, 0.024901125580072403, 0.004891638644039631, 0.03483446687459946, 0.016574934124946594, -0.0035604157019406557, 0.027302168309688568, -0.06269817054271698, 0.03648034483194351, 0.018240172415971756, -0.020796120166778564, -7.157213076425251e-06, 0.004485010635107756, -0.027979882434010506, 0.006525411736220121, -0.005000556819140911, 0.028657594695687294, -0.018240172415971756, -0.036596521735191345, -0.01933419518172741, 0.006399550940841436, -0.011356540024280548, 0.012731330469250679, -0.015451865270733833, -0.028483325615525246, 0.0035725177731364965, -0.0158681757748127, 0.016390983015298843, -0.00253900489769876, -0.010039839893579483, -0.012198841199278831, 0.016642704606056213, 0.0071643986739218235, 0.035976897925138474, -0.009943023324012756, 0.014270707964897156, 0.0036402891855686903, 0.0044027166441082954, -0.0009185436647385359, -0.002684229053556919, -0.024087870493531227, -0.007967973127961159, 0.00037001940654590726, -0.020679939538240433, -0.016981560736894608, 0.012179478071630001, 0.027863701805472374, 0.0067674522288143635, 0.027302168309688568, -0.014822560362517834, 0.023468246683478355, 0.010039839893579483, -0.01897597499191761, -0.023584425449371338, -0.012566742487251759, -0.025191575288772583, 0.02323588728904724, -0.006428595632314682, 0.006346301641315222, -0.007454847451299429, -0.00793408788740635]')
, COSINE)
FETCH EXACT FIRST 5 ROWS ONLY;
```
```
TITLE		       TEXT
------------------ ---------------------------------------------------------
青島 (京都府)        青島（あおしま）は、日本海の伊根湾に浮かぶ無人島。京
大神島             　大神島（おおがみじま）は、宮古列島の島のひとつである
大島 (徳島県)        海では珊瑚礁が広く分布しており、イサキやクマノミなど
野島 (山口県)        野島（のしま）は、山口県防府市の周南諸島に属し、瀬戸
浜島 (沖縄県)        浜島（はまじま、はましま）は、八重山列島にある小島で

経過: 00:00:24.24

```

それらしいチャンクが返されていますが、24 秒もかかっています。RAG を用いたアプリケーションでは、質問を受けると上のような情報を取得してから回答を生成することになるので、はじめの情報取得の時間を短縮したいところです。

そこで、ベクトル索引を作成します。

```sql
SET TIMING ON
CREATE VECTOR INDEX idx_wiki_ja_10k_embedding ON wiki_ja_10k_embedding (embedding)
ORGANIZATION INMEMORY NEIGHBOR GRAPH DISTANCE COSINE;
```
```
索引が作成されました。

経過: 00:00:32.56
```

先と同じ内容のクエリですが、今回は APPROX を付けて近似近傍検索で実行します。

```sql
SET TIMING ON
SELECT JSON_VALUE(metadata, '$.title') title, 
       SUBSTR(text, 0, 100) text
FROM wiki_ja_10k_embedding
ORDER BY VECTOR_DISTANCE(
  embedding
, TO_CLOB('[-0.01994413696229458, -0.03181380406022072, 0.01651684381067753, 0.07892456650733948, 0.02344888262450695, -0.010678826831281185, -0.04937626048922539, 0.01399962231516838, 0.05630830302834511, 0.02098975144326687, 0.010669144801795483, 0.04999588429927826, -0.028192877769470215, -0.010891822166740894, -0.0027205352671444416, -0.042328041046857834, -0.012634513899683952, 0.01235374715179205, 0.05781863257288933, 0.04046916961669922, 0.004412398207932711, -0.021009115502238274, 0.006646431982517242, -0.0021940970327705145, 0.02875441126525402, -0.03047773987054825, 0.06180746108293533, 0.012779738754034042, 0.004627814516425133, -0.012489289976656437, 0.038726478815078735, -0.03235597535967827, 0.04205695539712906, -0.039055656641721725, -0.02449449896812439, 0.029780663549900055, 0.045116350054740906, -0.03330477327108383, -0.02720535174012184, -0.051932208240032196, 0.02453322522342205, -0.012072980403900146, 0.027786249294877052, -0.017620548605918884, -0.03946228325366974, 0.06145892292261124, -0.043412383645772934, 0.00769204692915082, -0.005344254430383444, 0.011230679228901863, -0.0028221921529620886, 0.030361559242010117, -0.021435106173157692, -0.06374378502368927, -0.051235131919384, -0.01868552714586258, -0.002730216830968857, 0.05599848926067352, 0.012963688932359219, -0.01929546892642975, 0.035725176334381104, -0.019034065306186676, -0.023603789508342743, 0.06684190034866333, 0.04736248403787613, 0.004349467810243368, 0.016255440190434456, 0.022538810968399048, -0.06103293225169182, 0.020912298932671547, 0.03179444000124931, -0.002781045390293002, 0.005634702742099762, -0.008742502890527248, -0.01692347228527069, -0.0026503433473408222, -0.017523732036352158, -0.010640100575983524, -0.019673051312565804, 0.012072980403900146, -0.008200332522392273, 0.06986256688833237, -0.031871892511844635, -0.0031416856218129396, 0.06873950362205505, 0.03243342787027359, -0.005915469955652952, 0.05286164581775665, 0.01969241537153721, -0.046045783907175064, -0.04534870758652687, 0.0014098859392106533, -0.08062852919101715, 0.07888583838939667, -0.03134908527135849, -0.029141675680875778, -0.005092531908303499, 0.027902428060770035, 0.013370317406952381, -0.04902772232890129, -0.021919187158346176, -0.06343397498130798, -0.0067190444096922874, 0.02315843477845192, 0.014580519869923592, -0.01381567120552063, -0.023932963609695435, 0.02550138719379902, -0.06827478110790253, 0.022519448772072792, 0.00022887955128680915, -0.0023453724570572376, -0.012131069786846638, 0.07261215150356293, 0.009008747525513172, 0.04267657920718193, 0.050847869366407394, -0.025714382529258728, 0.06525412201881409, -0.03185252845287323, -0.02524966560304165, 0.01360267587006092, 0.054565608501434326, 0.024726856499910355, 0.004741573240607977, -0.02048630826175213, 0.008989384397864342, 0.035473454743623734, -0.004160676151514053, 0.025966104120016098, 0.035260461270809174, -0.04480653628706932, -0.03589944541454315, -0.012808782979846, 0.015577726066112518, 0.06107166036963463, 0.004678642842918634, 0.004349467810243368, -0.030787551775574684, 0.011947118677198887, 0.052513107657432556, 0.008084152825176716, 0.03229788318276405, -0.025520749390125275, 0.01821112632751465, -0.0035846198443323374, -0.006157510448247194, 0.014909694902598858, 0.010736916214227676, -0.014454658143222332, 0.011153225786983967, -0.025772472843527794, 0.022519448772072792, -0.02478494681417942, -0.05382980778813362, 0.034931283444166183, 0.017407553270459175, -0.03256896883249283, -0.012450562790036201, 0.04484526440501213, 0.009352444671094418, 0.006578660570085049, -0.00941537506878376, 0.01120163407176733, -0.004301059525460005, -0.04267657920718193, 0.02947085164487362, 0.01753341406583786, -0.036673977971076965, -0.003766150213778019, -0.017862588167190552, -0.021919187158346176, 0.04070153087377548, 0.003127163276076317, -0.014270707964897156, -0.02186109870672226, 0.03988827392458916, -0.045658521354198456, -0.010882141068577766, 0.06416977941989899, -0.0085488706827163')
||TO_CLOB('7, -0.023971691727638245, -0.09720346331596375, -0.004213924985378981, 0.013951214030385017, -0.03828112408518791, -0.007866316474974155, -0.00781306717544794, 0.020505670458078384, 0.0038411826826632023, 0.009565440937876701, -0.009700982831418514, 0.019847320392727852, -0.00799217727035284, -0.008669890463352203, 0.007135353982448578, -0.025985468178987503, -0.01556804496794939, 0.04887281730771065, -0.044457998126745224, 0.01918897032737732, -0.04643305018544197, 0.005746041424572468, 0.016894426196813583, -0.006418914068490267, 0.011230679228901863, -0.021222110837697983, -0.011492082849144936, 0.04302511736750603, -0.011830939911305904, 0.0006843695300631225, -0.002054923912510276, -0.007590389810502529, 0.024765584617853165, -0.0032820692285895348, -0.011240360327064991, 0.03758404776453972, -0.004204243421554565, -0.08907090127468109, -0.026256553828716278, 0.014628928154706955, -0.025462660938501358, 0.003378885332494974, -0.015955310314893723, -0.033420950174331665, 0.020370127633213997, 0.04105006903409958, 0.020931662991642952, 0.07350286096334457, 0.028057334944605827, 0.02428150363266468, 0.03150399029254913, -0.02337143011391163, -0.0308456402271986, 0.01767863892018795, -0.00021299564104992896, -0.012237567454576492, -0.037312962114810944, -0.019072791561484337, -0.011501764878630638, 0.021125294268131256, -0.013070186600089073, 0.0125376982614398, 0.01396089605987072, 0.045038897544145584, -0.03959782421588898, 0.001117016887292266, -0.019576234742999077, 0.04062407836318016, 0.018666163086891174, 0.03657716140151024, -0.023429520428180695, 0.042444221675395966, -0.044535450637340546, -0.04155351221561432, -0.006452799774706364, -0.0012011260259896517, 0.0267019085586071, 0.002068236004561186, 0.0151517353951931, 0.02842523530125618, 0.03163953498005867, -0.02027331292629242, -0.057741180062294006, -0.0015236448962241411, 0.007004652172327042, 0.00397672550752759, -0.0247074943035841, -0.0056201801635324955, -0.017485005781054497, 0.019392285495996475, -0.07346413284540176, -0.022422632202506065, -0.03202679753303528, -0.017223602160811424, 0.0029432123992592096, -0.05057678371667862, -0.051893483847379684, -0.02846396341919899, -0.04426436498761177, -0.0436447411775589, -0.014919376000761986, -0.010833732783794403, -0.00775497779250145, -0.009599326178431511, 0.012808782979846, -0.00709662726148963, -0.019256742671132088, -0.014706380665302277, 0.0067626116797327995, 0.0865924060344696, -0.024843037128448486, -0.02089293673634529, -0.026256553828716278, 0.008640846237540245, -0.030148563906550407, 0.029877478256821632, -0.021009115502238274, 0.013389680534601212, 0.026062920689582825, -0.018917884677648544, -0.01843380369246006, 0.02098975144326687, -0.016361936926841736, 0.0006680318037979305, 0.001613199943676591, -0.02875441126525402, -0.021164020523428917, 0.026759997010231018, 0.014125483110547066, 0.0007654530927538872, -0.036015626043081284, -0.020505670458078384, 0.022751806303858757, 0.0008931294432841241, -0.05382980778813362, -0.01587785594165325, 0.007914723828434944, 0.0015563203487545252, 0.01994413696229458, 0.00309327756986022, 0.03936546668410301, 0.006815860513597727, 0.00034763067378662527, -0.0703660100698471, 0.0024676029570400715, -0.024688130244612694, -0.029703209176659584, -0.027766885235905647, 0.029354671016335487, -0.039810821413993835, -0.014532111585140228, 0.06688062846660614, -0.007261214777827263, -0.02373933233320713, 0.007479051593691111, -0.044729083776474, 0.052435655146837234, -0.058167170733213425, 0.00709662726148963, -0.009008747525513172, -0.017194556072354317, 0.007450006436556578, 0.04956989362835884, -0.008084152825176716, 0.021086568012833595, 0.043373655527830124, -0.001032907865010202, -0.006820701062679291, -0.016545888036489487, -0.003746786853298545, 0.009638052433729172, 0.02428150363266468, -0.039694640785455704, 0.0167782474309206, -0.02441704459488392, 0.04809828847646713, -0.030748825520277023, -0.02428150363266468, 0.023565063253045082, -0.06684190034866')
||TO_CLOB('333, -0.053984712809324265, -0.010417423211038113, 0.06056821346282959, 0.009933342225849628, 0.01673952117562294, -0.042328041046857834, -0.03005174733698368, 0.018520938232541084, -0.003236081451177597, 0.021725555881857872, -0.007527459412813187, -0.05108022689819336, -0.007880838587880135, 0.02683744952082634, -0.032956235110759735, -0.0060461717657744884, -0.03506682813167572, 0.014018985442817211, 0.017794817686080933, -0.003635448170825839, 0.0171364676207304, -0.024475134909152985, 0.013341272249817848, -0.002461551921442151, 0.02583056129515171, 0.05692792683839798, -0.036054354161024094, 0.0239910539239645, 0.05530141294002533, 0.016110215336084366, 0.02395232766866684, 0.04534870758652687, 0.030942456796765327, 0.00035943015245720744, -0.018559664487838745, 0.0003878698917105794, 0.027786249294877052, -0.029393397271633148, 0.03344031423330307, -0.003809717483818531, -0.029490213841199875, -0.016323210671544075, 0.02799924463033676, 0.03272387385368347, 0.01648779958486557, -0.023623151704669, -0.04484526440501213, -0.022209636867046356, -0.002145688980817795, 0.002045242115855217, -0.061923641711473465, 0.03125226870179176, -0.019053427502512932, -0.005736359860748053, 0.028367146849632263, 0.018375715240836143, 0.02178364433348179, 0.026934266090393066, -0.08124815672636032, -0.002638241508975625, 0.029141675680875778, -0.03481510654091835, -0.009628371335566044, 0.04221186414361, 0.009284673258662224, 0.00852950755506754, 0.0006408022018149495, 0.0393267385661602, -0.035260461270809174, 0.025269027799367905, 0.00590578792616725, -0.037099968641996384, 0.029606394469738007, 0.028560778126120567, 0.017881952226161957, -0.011143544688820839, -0.001092812861315906, 0.009933342225849628, 0.003589460626244545, 0.039229925721883774, -0.05654066056013107, -0.01421261765062809, 0.020137770101428032, 0.04790465533733368, -0.010601373389363289, 0.04426436498761177, 0.03961718827486038, -0.028870590031147003, 0.0052958461456000805, 0.021686827763915062, -0.030361559242010117, 0.02240326814353466, 0.019276104867458344, 0.06560266017913818, 0.020331401377916336, -0.0364416167140007, -0.0027423189021646976, 0.015219506807625294, 0.006278530694544315, 0.0030400287359952927, 0.04902772232890129, -0.019750503823161125, -0.019063109531998634, -0.005082850344479084, -0.0151517353951931, -0.010078566148877144, 0.05526268482208252, -0.023274613544344902, 0.025385206565260887, -0.01517109852284193, 0.004874695558100939, -0.02337143011391163, -0.046123236417770386, -0.10231535881757736, 0.028851227834820747, -0.05425579845905304, -0.01582944765686989, -0.018307942897081375, -0.014406250789761543, -0.02608228474855423, 0.011172589845955372, 0.011947118677198887, 0.013873761519789696, 0.0009433528175577521, 0.024262139573693275, 0.019498782232403755, 0.029412761330604553, -0.05623084679245949, 0.02615973725914955, -0.031077999621629715, 0.028522051870822906, 0.04902772232890129, -0.003533791285008192, 0.030206654220819473, 0.003136844839900732, -0.03369203582406044, -0.007866316474974155, 0.0010087037226185203, 0.025423934683203697, -0.023061618208885193, -0.031116725876927376, -0.015887537971138954, 0.004652018193155527, -0.047168850898742676, -0.028657594695687294, -0.011017683893442154, -0.006259167101234198, 0.009047473780810833, 0.04356728866696358, -0.011724441312253475, 0.010920867323875427, -0.03289814293384552, -0.010659463703632355, 0.0007660581613890827, 0.0016749202040955424, -0.017184875905513763, 0.002638241508975625, -0.03578326851129532, -0.031116725876927376, -0.014048030599951744, 0.015209824778139591, 0.01702028699219227, -0.02972257323563099, 0.03595753759145737, 0.039810821413993835, -0.03262706100940704, 0.00160109787248075, 0.010707871988415718, 0.037603411823511124, -0.04840809851884842, -0.014135165140032768, -0.011095136404037476, 0.04430309310555458, 0.03940419480204582, -0.01918897032737732, 0.005010238382965326, -0.012508653104305267, 0.010707871988415718, 0.017475323751568794, 0.014503066428005695, 0.03719678')
||TO_CLOB('521156311, -0.010001113638281822, -0.012189159169793129, -0.04891154542565346, -0.02972257323563099, 0.020951025187969208, -0.026450185105204582, -0.025385206565260887, -0.022829260677099228, -0.008345556445419788, -0.023061618208885193, -0.03618989512324333, -0.015480910427868366, -0.010020476765930653, 0.012334384024143219, -0.009584804065525532, -0.0207380298525095, 0.013283182866871357, -0.0004332524840719998, -0.0004456570604816079, 0.02799924463033676, -0.01951814629137516, 0.02089293673634529, -0.0036427094601094723, -0.012760374695062637, -0.021706191822886467, -0.030613282695412636, 0.0028706002049148083, 2.8799036954296753e-05, 0.011153225786983967, -0.03324668109416962, -0.03038092330098152, 0.03332413733005524, -0.026972992345690727, 0.0012035464169457555, 0.012653877027332783, -0.014057711698114872, 0.022306451573967934, -0.012973370961844921, -0.007924405857920647, 0.011463037692010403, -0.021377017721533775, -0.011075773276388645, -0.02637273259460926, -0.014967784285545349, 0.02432022988796234, -0.00957996305078268, -0.004429341293871403, 0.019237378612160683, -0.024436408653855324, -0.0005076799425296485, 0.02712789922952652, 0.023971691727638245, -0.009734869003295898, -0.03235597535967827, 0.03833921626210213, 0.028115423396229744, -0.017049333080649376, -0.006752930115908384, 0.002166262362152338, 0.011337176896631718, 0.002519641537219286, -0.0031392653472721577, 0.00898454338312149, -0.03080691397190094, 0.010911185294389725, -0.03694505989551544, 0.023816784843802452, -0.010059203021228313, -0.01709774136543274, 0.006738407537341118, 0.0057412004098296165, 0.013196048326790333, 0.04530997946858406, -0.02997429482638836, 0.01414484716951847, 0.04542616009712219, -0.01908247359097004, 0.018714571371674538, 0.00620591826736927, -0.004734312184154987, 0.04174714535474777, 0.060878027230501175, -0.0024881763383746147, 0.009788117371499538, -0.009386330842971802, -0.012741011567413807, -0.010078566148877144, -0.030671371147036552, -0.0063705057837069035, 0.0059687187895178795, -0.01666206866502762, 0.011550172232091427, 0.0020912298932671547, 0.001656767213717103, -0.00917817559093237, 0.02428150363266468, -0.009110404178500175, 0.015345367603003979, 0.0017923099221661687, -0.039694640785455704, 0.004828707780689001, -0.016061807051301003, 7.819042366463691e-06, 0.020137770101428032, -0.010059203021228313, 0.041863325983285904, -0.006317256949841976, -0.017920678481459618, -0.010214108973741531, -0.01594562828540802, -0.03874584287405014, -0.03917183354496956, 0.02846396341919899, 0.03324668109416962, 0.02954830415546894, 0.017049333080649376, -0.00466170022264123, -0.016400665044784546, -0.012043935246765614, 0.037680864334106445, -0.013089549727737904, 0.0017184875905513763, 0.01580040343105793, -0.03841666877269745, 0.011821257881820202, 0.007217647507786751, 0.03959782421588898, 0.003478121943771839, 0.025985468178987503, 0.02135765366256237, 0.0017366405809298158, -0.01396089605987072, 0.01437720563262701, 0.007145035546272993, 0.020040953531861305, -0.023932963609695435, -0.006990129593759775, -0.03001302108168602, -0.0008205173071473837, 0.04465163126587868, 0.012866873294115067, -0.002243715338408947, -0.033169228583574295, -0.01821112632751465, -0.013050823472440243, -0.007900201715528965, -0.012818465009331703, -0.038513485342264175, -0.04705267399549484, -0.0024881763383746147, 0.009173334576189518, -0.016758883371949196, -0.004422079771757126, -0.001845558756031096, 0.038939476013183594, -0.002054923912510276, -0.0012900758301839232, 0.06254326552152634, -0.01433847937732935, -0.01356394961476326, -0.01835635118186474, -0.0085682338103652, -0.0063705057837069035, -0.00957512203603983, -0.039733368903398514, -0.020428217947483063, 0.03466019779443741, -0.02373933233320713, 0.017523732036352158, -0.0073628718964755535, -0.006278530694544315, 0.00042992443195544183, -0.006433436647057533, -0.009584804065525532, 0.012498971074819565, -0.0038823296781629324, -0.010978956706821918, 0.006772293243557215, ')
||TO_CLOB('-0.008815115317702293, 0.019053427502512932, 0.009444420225918293, 0.014861286617815495, 0.024126596748828888, -0.04732375964522362, -0.05657938867807388, 0.000339764344971627, 0.008374601602554321, -0.00590578792616725, -0.018414441496133804, -0.002660025143995881, 0.016691112890839577, 0.029606394469738007, 0.0026455025654286146, 0.027031082659959793, -0.04631686955690384, -0.01824985444545746, 0.0038605460431426764, -0.04197950288653374, -0.0018588710809126496, 0.0125376982614398, 0.04794338345527649, -0.011966481804847717, 0.007861475460231304, 0.0007836061413399875, -0.0011611892841756344, 0.006176873575896025, 0.0074838921427726746, -0.012431199662387371, 0.006259167101234198, 0.001208387198857963, -0.024804310873150826, -0.014522429555654526, 0.023565063253045082, -0.007266055792570114, 0.004378512501716614, -0.013079868629574776, 0.011927755549550056, -0.023352067917585373, 0.013312227092683315, 0.028309056535363197, 0.00012570979015436023, 0.030361559242010117, 0.009521872736513615, -0.01799813099205494, -0.05534014105796814, -0.016061807051301003, 0.0013711594510823488, -0.005063487216830254, -0.030652008950710297, -0.029877478256821632, -0.007750136777758598, 0.04217313602566719, 0.0023719968739897013, -0.015742313116788864, -0.017078377306461334, -0.004499532748013735, -0.023139070719480515, 0.013738218694925308, -0.0216481015086174, -0.006273689679801464, 0.012382792308926582, 0.008137401193380356, -0.016390983015298843, -0.01728169247508049, 0.017223602160811424, -0.001148482202552259, -0.0058961063623428345, -0.026256553828716278, -0.008849000558257103, -0.014125483110547066, -0.029161039739847183, 0.018240172415971756, 0.00878122914582491, 0.01732041873037815, -0.028405873104929924, -0.02683744952082634, -0.06006477028131485, 0.008868363685905933, -0.00399608863517642, -0.012595787644386292, 0.00769204692915082, -0.028638232499361038, -0.003855705028399825, 0.023894237354397774, -0.024901125580072403, 0.010310925543308258, -0.051970936357975006, 0.01435784250497818, -0.01591658405959606, 0.019508464261889458, -0.03285941854119301, -0.006041330751031637, 0.030671371147036552, 0.05104149878025055, 0.01255706138908863, -0.0062882122583687305, 0.012818465009331703, -0.024726856499910355, 0.05731518939137459, -0.0006389869377017021, 0.0019919932819902897, 0.0009754232014529407, -0.017262328416109085, -0.026895539835095406, 0.025385206565260887, -0.011085454374551773, -0.002994040958583355, 0.009153971448540688, -0.01868552714586258, -0.000645643041934818, -0.00016625157149974257, -0.01013665646314621, 0.03874584287405014, -0.014454658143222332, -0.03628671169281006, -0.002827032934874296, 0.03163953498005867, -0.040740255266427994, -0.0026358210016041994, 0.009981750510632992, -0.03481510654091835, 0.02792179211974144, -0.02402978017926216, -0.00037425511982291937, -0.008166446350514889, 0.05073168873786926, 0.04318002611398697, -0.0490664504468441, -0.0382423996925354, 0.009313718415796757, 0.026469549164175987, 0.007938927970826626, 0.021086568012833595, 0.07114054262638092, 0.017078377306461334, 0.003514427924528718, 0.026062920689582825, -0.009705823846161366, 0.013496178202331066, -0.02193855121731758, -0.019789231941103935, 0.054526884108781815, -0.026237189769744873, -0.01854030229151249, 0.022713080048561096, -0.004693165421485901, -0.05475924164056778, -0.02695363014936447, 0.023100344464182854, 0.012886236421763897, 0.0010474302107468247, -0.001958107575774193, 0.010310925543308258, 0.046045783907175064, -0.006772293243557215, -0.04000445455312729, -0.03233661130070686, 0.0064140730537474155, 0.05108022689819336, -0.01536473073065281, 0.012682922184467316, -0.03402121365070343, 0.021686827763915062, -0.02207409404218197, -0.012731330469250679, -0.002218301175162196, 0.01433847937732935, -0.002427666215226054, -0.01159858051687479, -0.010214108973741531, -0.011046728119254112, -0.02445577271282673, 0.041398607194423676, -0.022751806303858757, -0.005257119424641132, -0.0055717723444104195, 0.0609167516231536')
||TO_CLOB('87, -0.025443296879529953, -0.017039651051163673, 0.017901314422488213, -0.000878001912496984, 0.004477749112993479, -0.0019399545853957534, -0.002529323101043701, 0.03332413733005524, 0.032123614102602005, 0.009337922558188438, -0.021667465567588806, 0.02035076543688774, -0.007450006436556578, 0.0068400646559894085, -0.0062688491307199, 0.02980002574622631, 0.0250753965228796, -0.00862148217856884, 0.0037080603651702404, 0.027689432725310326, 0.009865570813417435, -0.0028657594230026007, 0.039559099823236465, 0.02641145884990692, -0.045542340725660324, 0.0010649781906977296, 0.010882141068577766, -0.03022601827979088, 0.04108879342675209, -0.011966481804847717, -0.0015526898205280304, 0.009700982831418514, 0.02879313752055168, -0.00011096044181613252, 0.019498782232403755, 0.016255440190434456, 0.028522051870822906, -0.03272387385368347, -0.018927566707134247, -0.03921056166291237, 0.028812501579523087, 0.051312584429979324, -0.0328400544822216, -0.03148462623357773, 0.021803008392453194, 0.005634702742099762, -0.013031460344791412, 0.004388194065541029, -0.0016386142233386636, 0.003935578279197216, -0.000111792454845272, 0.009671938605606556, 0.03557027131319046, 0.024300865828990936, 0.03477637842297554, -0.006230122409760952, 0.03984954580664635, 0.04043044522404671, 0.002882702276110649, 0.008045426569879055, -0.005746041424572468, 0.008853841572999954, 0.04895026981830597, 0.015161416493356228, 0.010097929276525974, -0.011753486469388008, -0.005954196210950613, 0.00379761541262269, -0.032665785402059555, 0.021202746778726578, 0.03088436834514141, -0.003700799308717251, 0.03305305168032646, -0.009822003543376923, 0.04372219741344452, 0.0046447571367025375, -0.03227851912379265, 0.027282804250717163, 0.05793481320142746, -0.004051757976412773, -0.020583124831318855, -0.009555758908390999, 0.04623941704630852, -0.034466568380594254, 0.00477061839774251, 0.0007521408260799944, -0.002761682029813528, 0.021086568012833595, 0.018462849780917168, 0.0022727602627128363, 0.02983875200152397, 0.014657972380518913, -0.015442184172570705, -0.008611801080405712, -0.005470115225762129, -0.00961384829133749, -0.005716996733099222, 0.01421261765062809, 0.006544774863868952, 0.004925524350255728, 0.01857902854681015, -0.013718855567276478, 0.023758694529533386, 0.00997206848114729, -0.02344888262450695, -0.019469738006591797, 0.06126528978347778, -0.02102847769856453, 0.005136099178344011, 0.003613664535805583, 0.042328041046857834, -0.02947085164487362, 0.027360258623957634, -0.021493196487426758, 0.010272198356688023, -0.007905042730271816, -0.0029432123992592096, -0.02131892740726471, 0.012653877027332783, -0.021803008392453194, -0.010465831495821476, 0.011433993466198444, -0.014415931887924671, 0.0008773967856541276, -0.009308877401053905, -0.0082100136205554, 0.002065815730020404, 0.0005061671836301684, -0.026140373200178146, 0.03235597535967827, 0.002851237077265978, -0.022461358457803726, 0.010146337561309338, -0.025656292214989662, -0.015393775887787342, 0.031194180250167847, 0.019827958196401596, -0.02337143011391163, 0.012731330469250679, -0.019053427502512932, -0.0026672862004488707, 0.010959593579173088, -0.005504000931978226, 0.01598435454070568, -0.021105932071805, 0.032375335693359375, 0.043528564274311066, -0.0008568233461119235, 0.0068981540389359, -0.021415743976831436, -0.011230679228901863, -0.052474379539489746, -0.004676222335547209, 0.013922169804573059, 0.03384694457054138, 0.017146149650216103, 0.04910517483949661, -0.006278530694544315, 0.020621851086616516, -0.02550138719379902, -0.01255706138908863, -0.027611980214715004, -0.002638241508975625, 0.01536473073065281, -0.018966292962431908, 0.010252835229039192, -0.0125376982614398, -0.008907089941203594, 0.011211316101253033, 0.027476437389850616, 0.010698189958930016, 0.013728536665439606, 0.03779704496264458, -0.004429341293871403, -0.014870968647301197, -0.021415743976831436, -0.06273689866065979, 0.023603789508342743, -0.009531554765999317, -0.003366783261299')
||TO_CLOB('1333, 0.01644907146692276, 0.006869109347462654, 0.006990129593759775, -0.027786249294877052, 0.03665461391210556, 0.010814369656145573, 0.018666163086891174, -0.005320050287991762, -0.010301243513822556, -0.011869666166603565, 0.02662445418536663, -0.001976260682567954, 0.003800035919994116, -0.009913979098200798, -0.007411280181258917, -0.0111822709441185, 0.023797422647476196, 0.03988827392458916, 0.0012610310222953558, -0.02009904384613037, -0.005867061670869589, -0.010146337561309338, -0.04678158834576607, 0.02139637991786003, 0.049879707396030426, 0.009313718415796757, 0.048137012869119644, 0.0155099555850029, 0.007280578371137381, 0.02879313752055168, 0.01237311027944088, 0.010097929276525974, 0.002836714731529355, -0.008916771970689297, 0.0069659254513680935, -0.0030884367879480124, -0.0033837261144071817, 0.027050446718931198, -0.027766885235905647, -0.025520749390125275, -0.008118038065731525, 0.015277596190571785, -0.023022891953587532, 0.007508096285164356, 0.007967973127961159, -0.01122099719941616, -0.022887349128723145, -0.00041267904452979565, -0.03274323791265488, 0.013157321140170097, -0.02918040193617344, -0.02524966560304165, -0.02929658256471157, 0.002461551921442151, -0.023352067917585373, -0.00899906549602747, -0.0017160670831799507, 0.010417423211038113, -0.006941721308976412, -0.042405493557453156, 0.01644907146692276, -0.0335371308028698, 0.016061807051301003, -0.04728503152728081, 0.0160521250218153, -0.02511412277817726, 0.03357585892081261, 0.03938483074307442, 0.02244199439883232, 0.02377805858850479, -0.011104818433523178, -0.018598392605781555, 0.010736916214227676, 0.0020065156277269125, -0.012450562790036201, 0.002616457873955369, -0.0068981540389359, 0.04786592721939087, -0.011211316101253033, 0.0055427271872758865, 0.05704410374164581, -0.022132182493805885, -0.011211316101253033, -0.02708917297422886, 0.001811673166230321, -0.015674542635679245, -0.026934266090393066, 0.03909438103437424, 0.020466944202780724, -0.03539600223302841, -0.023255251348018646, 0.009003906510770321, -0.01017538271844387, -0.002476074267178774, 0.043993279337882996, -0.0008047846495173872, 0.02348761074244976, -0.007730773650109768, -0.0038702276069670916, 0.03804876655340195, 0.0027665228117257357, 0.006075216457247734, 0.003100538859143853, 0.011908392421901226, 0.03477637842297554, -0.02838650904595852, -0.000353379116859287, 0.011850303038954735, -0.004129210952669382, -0.010959593579173088, -0.01979891210794449, 0.021686827763915062, -0.011250042356550694, 0.012992734089493752, -0.010243154130876064, 0.015538999810814857, -0.007566186133772135, 0.024765584617853165, -0.017698001116514206, -0.01619734987616539, 0.010039839893579483, 0.00478998152539134, 0.005334572400897741, -0.04488398879766464, -0.016497479751706123, 0.004581826739013195, 0.011569535359740257, 0.007343508768826723, -0.014231981709599495, -2.0422166926437058e-05, 0.039559099823236465, -0.00309327756986022, 0.007382235024124384, 0.008887726813554764, -0.017465641722083092, -0.0025777313858270645, 0.02106720581650734, 0.03574454039335251, 0.011153225786983967, -0.009463783353567123, -0.013070186600089073, 0.018278898671269417, 0.008093833923339844, 0.02828969433903694, -0.03444720432162285, -0.026140373200178146, -0.005305527709424496, -0.07001747190952301, 0.0033522609155625105, -0.030826278030872345, 0.010117292404174805, 0.013757581822574139, 0.003006143029779196, 0.01832730695605278, -0.0357058160007, -0.03359522297978401, 0.03287878260016441, -0.011569535359740257, -0.040856435894966125, -0.011540491133928299, -0.0076387980952858925, -0.032917506992816925, 0.011753486469388008, -0.005073168780654669, -0.015538999810814857, 0.006317256949841976, -0.011627625674009323, 0.01341872476041317, -0.008088993839919567, -0.019721459597349167, -0.046161964535713196, 0.04217313602566719, 0.02997429482638836, -0.004163096658885479, -0.02366187982261181, -0.0034369751811027527, 0.024630041792988777, 0.015926264226436615, 0.0022231419570744038, -0.0116469')
||TO_CLOB('88801658154, 0.006932039745151997, -0.02983875200152397, 0.021338289603590965, 0.006191396154463291, -0.008118038065731525, -0.026682544499635696, 0.015645498409867287, 0.0267019085586071, -0.00956059992313385, -0.007803385611623526, 0.010853095911443233, -0.009696142747998238, -0.020796120166778564, 0.00400334969162941, -0.004209084436297417, 0.0028706002049148083, 0.009734869003295898, 0.004378512501716614, 0.015674542635679245, 0.029025496914982796, 0.004540679976344109, 0.0007200705003924668, -0.0070433784276247025, 0.041359879076480865, 0.029664482921361923, 0.004608450923115015, 0.02550138719379902, 0.005058646202087402, -0.001401414512656629, 0.028115423396229744, 0.013951214030385017, 0.017000924795866013, 0.03314986824989319, 0.01872425340116024, -0.030865004286170006, -0.005581453908234835, 0.014929058030247688, 0.007725932635366917, 0.018956610932946205, -0.008902249857783318, -0.040740255266427994, 0.005784767679870129, -0.01706869527697563, -0.008239058777689934, -0.0026091965846717358, 0.05425579845905304, -0.036383528262376785, 0.025849925354123116, -0.00038060868973843753, -0.004293798469007015, -0.03361458331346512, -0.014057711698114872, 0.014270707964897156, -0.024610677734017372, 0.0005185717600397766, 0.022829260677099228, -0.03595753759145737, 0.03729360178112984, -0.02737962082028389, 0.024378318339586258, 0.029432125389575958, 0.006738407537341118, 0.03777768090367317, 0.006118783727288246, -0.008297148160636425, 0.0012186738895252347, -0.029606394469738007, 0.021047841757535934, -0.02821223996579647, -0.03466019779443741, 0.01094991248100996, 0.0005215972778387368, -0.03369203582406044, -0.0013203308917582035, 0.008456895127892494, 0.015374412760138512, -0.00340066896751523, -0.010330288670957088, -0.0026987516321241856, -0.026488911360502243, 0.013660766184329987, -0.024358956143260002, -0.00862148217856884, 0.0018963873153552413, 0.00519418902695179, -0.0027786248829215765, 0.021764282137155533, -0.0026914903428405523, 0.035008735954761505, -0.029993658885359764, -0.0021819951944053173, 0.005087691359221935, -0.014638609252870083, 0.009623530320823193, -0.02590801566839218, -0.012431199662387371, -0.01832730695605278, 0.011511445976793766, -0.0007134143961593509, 0.00407838262617588, -0.023003529757261276, -0.014222299680113792, -0.04019808769226074, -0.02139637991786003, 0.035550907254219055, -0.028367146849632263, -0.020834846422076225, 0.01475478895008564, -0.02048630826175213, -0.013157321140170097, -0.003313534427434206, -0.059290241450071335, 0.0003061812312807888, -0.01096927560865879, 0.010678826831281185, 0.021803008392453194, -0.049724798649549484, -0.02031203918159008, -0.005794449709355831, 0.020505670458078384, 0.044457998126745224, -0.017765773460268974, -0.007880838587880135, 9.530344686936587e-05, 0.031116725876927376, -0.0011841831728816032, 0.03378885239362717, 0.03328540921211243, 0.011859984137117863, 0.0007708990015089512, -0.01093054935336113, -0.02950957790017128, -0.010746598243713379, -0.007425802294164896, -0.0007557714707218111, 0.0003697168722283095, 0.006157510448247194, -0.01821112632751465, 0.02395232766866684, -0.003226399887353182, 0.0001266930776182562, -0.020079679787158966, 0.008713457733392715, 0.0028657594230026007, 0.00999143160879612, -0.008897408843040466, 0.011414630338549614, -0.0015696326736360788, -0.004429341293871403, -0.04228931665420532, 0.0019387444481253624, -0.00011421286035329103, 0.010243154130876064, -0.01652652584016323, -0.05545631796121597, -0.022538810968399048, 0.004627814516425133, -0.018811387941241264, 0.006956243887543678, -0.02265498973429203, -0.020505670458078384, -0.03177507594227791, 0.04484526440501213, 0.014948421157896519, -0.0023235888220369816, 0.009797799400985241, 0.029432125389575958, -0.006051012314856052, -0.005838016979396343, 0.003877488896250725, 0.003775831777602434, 0.02294543944299221, -0.02662445418536663, 0.015577726066112518, -0.007145035546272993, 0.03314986824989319, 0.004095325246453285, -0.003654811531305313, ')
||TO_CLOB('0.025404570624232292, 0.004724630620330572, -0.004356728866696358, -0.015703586861491203, 0.029935568571090698, -0.005779927130788565, -0.015316322445869446, -0.012072980403900146, 0.017146149650216103, -0.012344065122306347, -0.011443674564361572, -0.016933152452111244, 0.0041267904452979565, 0.014444977045059204, 0.031910620629787445, -0.005828335415571928, -0.01237311027944088, -0.036809518933296204, -0.016255440190434456, -0.009749391116201878, -0.0007963132229633629, 0.026179099455475807, 0.043954554945230484, 0.023390794172883034, -0.02575310878455639, -0.03148462623357773, 0.0022473460994660854, -0.011250042356550694, 0.028948044404387474, 0.027805613353848457, 0.026217827573418617, 0.006694840267300606, 0.0026648659259080887, -0.02135765366256237, 0.10161828249692917, -0.02708917297422886, -0.014599882997572422, -0.02207409404218197, 0.010591692291200161, 0.024901125580072403, 0.004891638644039631, 0.03483446687459946, 0.016574934124946594, -0.0035604157019406557, 0.027302168309688568, -0.06269817054271698, 0.03648034483194351, 0.018240172415971756, -0.020796120166778564, -7.157213076425251e-06, 0.004485010635107756, -0.027979882434010506, 0.006525411736220121, -0.005000556819140911, 0.028657594695687294, -0.018240172415971756, -0.036596521735191345, -0.01933419518172741, 0.006399550940841436, -0.011356540024280548, 0.012731330469250679, -0.015451865270733833, -0.028483325615525246, 0.0035725177731364965, -0.0158681757748127, 0.016390983015298843, -0.00253900489769876, -0.010039839893579483, -0.012198841199278831, 0.016642704606056213, 0.0071643986739218235, 0.035976897925138474, -0.009943023324012756, 0.014270707964897156, 0.0036402891855686903, 0.0044027166441082954, -0.0009185436647385359, -0.002684229053556919, -0.024087870493531227, -0.007967973127961159, 0.00037001940654590726, -0.020679939538240433, -0.016981560736894608, 0.012179478071630001, 0.027863701805472374, 0.0067674522288143635, 0.027302168309688568, -0.014822560362517834, 0.023468246683478355, 0.010039839893579483, -0.01897597499191761, -0.023584425449371338, -0.012566742487251759, -0.025191575288772583, 0.02323588728904724, -0.006428595632314682, 0.006346301641315222, -0.007454847451299429, -0.00793408788740635]')
, COSINE)
FETCH APPROX FIRST 5 ROWS ONLY;
```
```
TITLE		       TEXT
------------------ ---------------------------------------------------------
青島 (京都府)        青島（あおしま）は、日本海の伊根湾に浮かぶ無人島。京
大神島               大神島（おおがみじま）は、宮古列島の島のひとつである
大島 (徳島県)        海では珊瑚礁が広く分布しており、イサキやクマノミなど
野島 (山口県)        野島（のしま）は、山口県防府市の周南諸島に属し、瀬戸
浜島 (沖縄県)        浜島（はまじま、はましま）は、八重山列島にある小島で

経過: 00:00:00.01
```

実行時間は 0.01 秒と大幅に短縮されました！

今回の場合、結果は完全近傍検索と一致していますが、近似近傍検索の結果は異なる場合もあります。その精度を許容できる場合には、ベクトル索引により大きな性能向上を得られることがわかりました。検索対象のデータ量がさらに多くなっていったときには、近似近傍検索が不可欠となることが想像できます。

上記で使用した wiki_ja_10k_embedding 表の作成過程や LangChain を使ったベクトル索引の使い方は [こちらの記事](https://qiita.com/xkzm/items/eb4b1445fa8baf671111) で説明しているので、詳しく知りたい方はぜひご参照ください。

## 参考） 質問のベクトルの取得

上のクエリで使用した質問のベクトル表現は、以下のように OpenAI の API を用いて取得しました。生成された結果（ここでは embedding）には [権利を主張しない](https://help.openai.com/en/articles/5008634-will-openai-claim-copyright-over-what-outputs-i-generate-with-the-api) とされていることから、検索対象の表も含めて embedding を公開させていただいています。

```python
from langchain_openai import OpenAIEmbeddings
import os

query = "日本の離島について教えて下さい"

os.environ["OPENAI_API_KEY"] = "<openai_api_key>"
model = OpenAIEmbeddings(model = "text-embedding-3-small")
embedding_vector = model.embed_query(query)

def split_text(text, chunk_size=4000):
    return [text[i:i + chunk_size] for i in range(0, len(text), chunk_size)]

chunks = split_text(str(embedding_vector))

for i, chunk in enumerate(chunks):
    print("||TO_CLOB('" + chunk + "')")
```
```
||TO_CLOB('[-0.01994413696229458, -0.03181380406022072, 0.01651684381067753, 0.07892456650733948, 0.02344888262450695, -0.010678826831281185, -0.04937626048922539, 0.01399962231516838, 0.05630830302834511, 0.02098975144326687, 0.010669144801795483, 0.04999588429927826, -0.028192877769470215, -0.010891822166740894, -0.0027205352671444416, -0.042328041046857834, -0.012634513899683952, 0.01235374715179205, 0.05781863257288933, 0.04046916961669922, 0.004412398207932711, -0.021009115502238274, 0.006646431982517242, -0.0021940970327705145, 0.02875441126525402, -0.03047773987054825, 0.06180746108293533, 0.012779738754034042, 0.004627814516425133, -0.012489289976656437, 0.038726478815078735, -0.03235597535967827, 0.04205695539712906, -0.039055656641721725, -0.02449449896812439, 0.029780663549900055, 0.045116350054740906, -0.03330477327108383, -0.02720535174012184, -0.051932208240032196, 0.02453322522342205, -0.012072980403900146, 0.027786249294877052, -0.017620548605918884, -0.03946228325366974, 0.06145892292261124, -0.043412383645772934, 0.00769204692915082, -0.005344254430383444, 0.011230679228901863, -0.0028221921529620886, 0.030361559242010117, -0.021435106173157692, -0.06374378502368927, -0.051235131919384, -0.01868552714586258, -0.002730216830968857, 0.05599848926067352, 0.012963688932359219, -0.01929546892642975, 0.035725176334381104, -0.019034065306186676, -0.023603789508342743, 0.06684190034866333, 0.04736248403787613, 0.004349467810243368, 0.016255440190434456, 0.022538810968399048, -0.06103293225169182, 0.020912298932671547, 0.03179444000124931, -0.002781045390293002, 0.005634702742099762, -0.008742502890527248, -0.01692347228527069, -0.0026503433473408222, -0.017523732036352158, -0.010640100575983524, -0.019673051312565804, 0.012072980403900146, -0.008200332522392273, 0.06986256688833237, -0.031871892511844635, -0.0031416856218129396, 0.06873950362205505, 0.03243342787027359, -0.005915469955652952, 0.05286164581775665, 0.01969241537153721, -0.046045783907175064, -0.04534870758652687, 0.0014098859392106533, -0.08062852919101715, 0.07888583838939667, -0.03134908527135849, -0.029141675680875778, -0.005092531908303499, 0.027902428060770035, 0.013370317406952381, -0.04902772232890129, -0.021919187158346176, -0.06343397498130798, -0.0067190444096922874, 0.02315843477845192, 0.014580519869923592, -0.01381567120552063, -0.023932963609695435, 0.02550138719379902, -0.06827478110790253, 0.022519448772072792, 0.00022887955128680915, -0.0023453724570572376, -0.012131069786846638, 0.07261215150356293, 0.009008747525513172, 0.04267657920718193, 0.050847869366407394, -0.025714382529258728, 0.06525412201881409, -0.03185252845287323, -0.02524966560304165, 0.01360267587006092, 0.054565608501434326, 0.024726856499910355, 0.004741573240607977, -0.02048630826175213, 0.008989384397864342, 0.035473454743623734, -0.004160676151514053, 0.025966104120016098, 0.035260461270809174, -0.04480653628706932, -0.03589944541454315, -0.012808782979846, 0.015577726066112518, 0.06107166036963463, 0.004678642842918634, 0.004349467810243368, -0.030787551775574684, 0.011947118677198887, 0.052513107657432556, 0.008084152825176716, 0.03229788318276405, -0.025520749390125275, 0.01821112632751465, -0.0035846198443323374, -0.006157510448247194, 0.014909694902598858, 0.010736916214227676, -0.014454658143222332, 0.011153225786983967, -0.025772472843527794, 0.022519448772072792, -0.02478494681417942, -0.05382980778813362, 0.034931283444166183, 0.017407553270459175, -0.03256896883249283, -0.012450562790036201, 0.04484526440501213, 0.009352444671094418, 0.006578660570085049, -0.00941537506878376, 0.01120163407176733, -0.004301059525460005, -0.04267657920718193, 0.02947085164487362, 0.01753341406583786, -0.036673977971076965, -0.003766150213778019, -0.017862588167190552, -0.021919187158346176, 0.04070153087377548, 0.003127163276076317, -0.014270707964897156, -0.02186109870672226, 0.03988827392458916, -0.045658521354198456, -0.010882141068577766, 0.06416977941989899, -0.0085488706827163')
||TO_CLOB('7, -0.023971691727638245, -0.09720346331596375, -0.004213924985378981, 0.013951214030385017, -0.03828112408518791, -0.007866316474974155, -0.00781306717544794, 0.020505670458078384, 0.0038411826826632023, 0.009565440937876701, -0.009700982831418514, 0.019847320392727852, -0.00799217727035284, -0.008669890463352203, 0.007135353982448578, -0.025985468178987503, -0.01556804496794939, 0.04887281730771065, -0.044457998126745224, 0.01918897032737732, -0.04643305018544197, 0.005746041424572468, 0.016894426196813583, -0.006418914068490267, 0.011230679228901863, -0.021222110837697983, -0.011492082849144936, 0.04302511736750603, -0.011830939911305904, 0.0006843695300631225, -0.002054923912510276, -0.007590389810502529, 0.024765584617853165, -0.0032820692285895348, -0.011240360327064991, 0.03758404776453972, -0.004204243421554565, -0.08907090127468109, -0.026256553828716278, 0.014628928154706955, -0.025462660938501358, 0.003378885332494974, -0.015955310314893723, -0.033420950174331665, 0.020370127633213997, 0.04105006903409958, 0.020931662991642952, 0.07350286096334457, 0.028057334944605827, 0.02428150363266468, 0.03150399029254913, -0.02337143011391163, -0.0308456402271986, 0.01767863892018795, -0.00021299564104992896, -0.012237567454576492, -0.037312962114810944, -0.019072791561484337, -0.011501764878630638, 0.021125294268131256, -0.013070186600089073, 0.0125376982614398, 0.01396089605987072, 0.045038897544145584, -0.03959782421588898, 0.001117016887292266, -0.019576234742999077, 0.04062407836318016, 0.018666163086891174, 0.03657716140151024, -0.023429520428180695, 0.042444221675395966, -0.044535450637340546, -0.04155351221561432, -0.006452799774706364, -0.0012011260259896517, 0.0267019085586071, 0.002068236004561186, 0.0151517353951931, 0.02842523530125618, 0.03163953498005867, -0.02027331292629242, -0.057741180062294006, -0.0015236448962241411, 0.007004652172327042, 0.00397672550752759, -0.0247074943035841, -0.0056201801635324955, -0.017485005781054497, 0.019392285495996475, -0.07346413284540176, -0.022422632202506065, -0.03202679753303528, -0.017223602160811424, 0.0029432123992592096, -0.05057678371667862, -0.051893483847379684, -0.02846396341919899, -0.04426436498761177, -0.0436447411775589, -0.014919376000761986, -0.010833732783794403, -0.00775497779250145, -0.009599326178431511, 0.012808782979846, -0.00709662726148963, -0.019256742671132088, -0.014706380665302277, 0.0067626116797327995, 0.0865924060344696, -0.024843037128448486, -0.02089293673634529, -0.026256553828716278, 0.008640846237540245, -0.030148563906550407, 0.029877478256821632, -0.021009115502238274, 0.013389680534601212, 0.026062920689582825, -0.018917884677648544, -0.01843380369246006, 0.02098975144326687, -0.016361936926841736, 0.0006680318037979305, 0.001613199943676591, -0.02875441126525402, -0.021164020523428917, 0.026759997010231018, 0.014125483110547066, 0.0007654530927538872, -0.036015626043081284, -0.020505670458078384, 0.022751806303858757, 0.0008931294432841241, -0.05382980778813362, -0.01587785594165325, 0.007914723828434944, 0.0015563203487545252, 0.01994413696229458, 0.00309327756986022, 0.03936546668410301, 0.006815860513597727, 0.00034763067378662527, -0.0703660100698471, 0.0024676029570400715, -0.024688130244612694, -0.029703209176659584, -0.027766885235905647, 0.029354671016335487, -0.039810821413993835, -0.014532111585140228, 0.06688062846660614, -0.007261214777827263, -0.02373933233320713, 0.007479051593691111, -0.044729083776474, 0.052435655146837234, -0.058167170733213425, 0.00709662726148963, -0.009008747525513172, -0.017194556072354317, 0.007450006436556578, 0.04956989362835884, -0.008084152825176716, 0.021086568012833595, 0.043373655527830124, -0.001032907865010202, -0.006820701062679291, -0.016545888036489487, -0.003746786853298545, 0.009638052433729172, 0.02428150363266468, -0.039694640785455704, 0.0167782474309206, -0.02441704459488392, 0.04809828847646713, -0.030748825520277023, -0.02428150363266468, 0.023565063253045082, -0.06684190034866')
||TO_CLOB('333, -0.053984712809324265, -0.010417423211038113, 0.06056821346282959, 0.009933342225849628, 0.01673952117562294, -0.042328041046857834, -0.03005174733698368, 0.018520938232541084, -0.003236081451177597, 0.021725555881857872, -0.007527459412813187, -0.05108022689819336, -0.007880838587880135, 0.02683744952082634, -0.032956235110759735, -0.0060461717657744884, -0.03506682813167572, 0.014018985442817211, 0.017794817686080933, -0.003635448170825839, 0.0171364676207304, -0.024475134909152985, 0.013341272249817848, -0.002461551921442151, 0.02583056129515171, 0.05692792683839798, -0.036054354161024094, 0.0239910539239645, 0.05530141294002533, 0.016110215336084366, 0.02395232766866684, 0.04534870758652687, 0.030942456796765327, 0.00035943015245720744, -0.018559664487838745, 0.0003878698917105794, 0.027786249294877052, -0.029393397271633148, 0.03344031423330307, -0.003809717483818531, -0.029490213841199875, -0.016323210671544075, 0.02799924463033676, 0.03272387385368347, 0.01648779958486557, -0.023623151704669, -0.04484526440501213, -0.022209636867046356, -0.002145688980817795, 0.002045242115855217, -0.061923641711473465, 0.03125226870179176, -0.019053427502512932, -0.005736359860748053, 0.028367146849632263, 0.018375715240836143, 0.02178364433348179, 0.026934266090393066, -0.08124815672636032, -0.002638241508975625, 0.029141675680875778, -0.03481510654091835, -0.009628371335566044, 0.04221186414361, 0.009284673258662224, 0.00852950755506754, 0.0006408022018149495, 0.0393267385661602, -0.035260461270809174, 0.025269027799367905, 0.00590578792616725, -0.037099968641996384, 0.029606394469738007, 0.028560778126120567, 0.017881952226161957, -0.011143544688820839, -0.001092812861315906, 0.009933342225849628, 0.003589460626244545, 0.039229925721883774, -0.05654066056013107, -0.01421261765062809, 0.020137770101428032, 0.04790465533733368, -0.010601373389363289, 0.04426436498761177, 0.03961718827486038, -0.028870590031147003, 0.0052958461456000805, 0.021686827763915062, -0.030361559242010117, 0.02240326814353466, 0.019276104867458344, 0.06560266017913818, 0.020331401377916336, -0.0364416167140007, -0.0027423189021646976, 0.015219506807625294, 0.006278530694544315, 0.0030400287359952927, 0.04902772232890129, -0.019750503823161125, -0.019063109531998634, -0.005082850344479084, -0.0151517353951931, -0.010078566148877144, 0.05526268482208252, -0.023274613544344902, 0.025385206565260887, -0.01517109852284193, 0.004874695558100939, -0.02337143011391163, -0.046123236417770386, -0.10231535881757736, 0.028851227834820747, -0.05425579845905304, -0.01582944765686989, -0.018307942897081375, -0.014406250789761543, -0.02608228474855423, 0.011172589845955372, 0.011947118677198887, 0.013873761519789696, 0.0009433528175577521, 0.024262139573693275, 0.019498782232403755, 0.029412761330604553, -0.05623084679245949, 0.02615973725914955, -0.031077999621629715, 0.028522051870822906, 0.04902772232890129, -0.003533791285008192, 0.030206654220819473, 0.003136844839900732, -0.03369203582406044, -0.007866316474974155, 0.0010087037226185203, 0.025423934683203697, -0.023061618208885193, -0.031116725876927376, -0.015887537971138954, 0.004652018193155527, -0.047168850898742676, -0.028657594695687294, -0.011017683893442154, -0.006259167101234198, 0.009047473780810833, 0.04356728866696358, -0.011724441312253475, 0.010920867323875427, -0.03289814293384552, -0.010659463703632355, 0.0007660581613890827, 0.0016749202040955424, -0.017184875905513763, 0.002638241508975625, -0.03578326851129532, -0.031116725876927376, -0.014048030599951744, 0.015209824778139591, 0.01702028699219227, -0.02972257323563099, 0.03595753759145737, 0.039810821413993835, -0.03262706100940704, 0.00160109787248075, 0.010707871988415718, 0.037603411823511124, -0.04840809851884842, -0.014135165140032768, -0.011095136404037476, 0.04430309310555458, 0.03940419480204582, -0.01918897032737732, 0.005010238382965326, -0.012508653104305267, 0.010707871988415718, 0.017475323751568794, 0.014503066428005695, 0.03719678')
||TO_CLOB('521156311, -0.010001113638281822, -0.012189159169793129, -0.04891154542565346, -0.02972257323563099, 0.020951025187969208, -0.026450185105204582, -0.025385206565260887, -0.022829260677099228, -0.008345556445419788, -0.023061618208885193, -0.03618989512324333, -0.015480910427868366, -0.010020476765930653, 0.012334384024143219, -0.009584804065525532, -0.0207380298525095, 0.013283182866871357, -0.0004332524840719998, -0.0004456570604816079, 0.02799924463033676, -0.01951814629137516, 0.02089293673634529, -0.0036427094601094723, -0.012760374695062637, -0.021706191822886467, -0.030613282695412636, 0.0028706002049148083, 2.8799036954296753e-05, 0.011153225786983967, -0.03324668109416962, -0.03038092330098152, 0.03332413733005524, -0.026972992345690727, 0.0012035464169457555, 0.012653877027332783, -0.014057711698114872, 0.022306451573967934, -0.012973370961844921, -0.007924405857920647, 0.011463037692010403, -0.021377017721533775, -0.011075773276388645, -0.02637273259460926, -0.014967784285545349, 0.02432022988796234, -0.00957996305078268, -0.004429341293871403, 0.019237378612160683, -0.024436408653855324, -0.0005076799425296485, 0.02712789922952652, 0.023971691727638245, -0.009734869003295898, -0.03235597535967827, 0.03833921626210213, 0.028115423396229744, -0.017049333080649376, -0.006752930115908384, 0.002166262362152338, 0.011337176896631718, 0.002519641537219286, -0.0031392653472721577, 0.00898454338312149, -0.03080691397190094, 0.010911185294389725, -0.03694505989551544, 0.023816784843802452, -0.010059203021228313, -0.01709774136543274, 0.006738407537341118, 0.0057412004098296165, 0.013196048326790333, 0.04530997946858406, -0.02997429482638836, 0.01414484716951847, 0.04542616009712219, -0.01908247359097004, 0.018714571371674538, 0.00620591826736927, -0.004734312184154987, 0.04174714535474777, 0.060878027230501175, -0.0024881763383746147, 0.009788117371499538, -0.009386330842971802, -0.012741011567413807, -0.010078566148877144, -0.030671371147036552, -0.0063705057837069035, 0.0059687187895178795, -0.01666206866502762, 0.011550172232091427, 0.0020912298932671547, 0.001656767213717103, -0.00917817559093237, 0.02428150363266468, -0.009110404178500175, 0.015345367603003979, 0.0017923099221661687, -0.039694640785455704, 0.004828707780689001, -0.016061807051301003, 7.819042366463691e-06, 0.020137770101428032, -0.010059203021228313, 0.041863325983285904, -0.006317256949841976, -0.017920678481459618, -0.010214108973741531, -0.01594562828540802, -0.03874584287405014, -0.03917183354496956, 0.02846396341919899, 0.03324668109416962, 0.02954830415546894, 0.017049333080649376, -0.00466170022264123, -0.016400665044784546, -0.012043935246765614, 0.037680864334106445, -0.013089549727737904, 0.0017184875905513763, 0.01580040343105793, -0.03841666877269745, 0.011821257881820202, 0.007217647507786751, 0.03959782421588898, 0.003478121943771839, 0.025985468178987503, 0.02135765366256237, 0.0017366405809298158, -0.01396089605987072, 0.01437720563262701, 0.007145035546272993, 0.020040953531861305, -0.023932963609695435, -0.006990129593759775, -0.03001302108168602, -0.0008205173071473837, 0.04465163126587868, 0.012866873294115067, -0.002243715338408947, -0.033169228583574295, -0.01821112632751465, -0.013050823472440243, -0.007900201715528965, -0.012818465009331703, -0.038513485342264175, -0.04705267399549484, -0.0024881763383746147, 0.009173334576189518, -0.016758883371949196, -0.004422079771757126, -0.001845558756031096, 0.038939476013183594, -0.002054923912510276, -0.0012900758301839232, 0.06254326552152634, -0.01433847937732935, -0.01356394961476326, -0.01835635118186474, -0.0085682338103652, -0.0063705057837069035, -0.00957512203603983, -0.039733368903398514, -0.020428217947483063, 0.03466019779443741, -0.02373933233320713, 0.017523732036352158, -0.0073628718964755535, -0.006278530694544315, 0.00042992443195544183, -0.006433436647057533, -0.009584804065525532, 0.012498971074819565, -0.0038823296781629324, -0.010978956706821918, 0.006772293243557215, ')
||TO_CLOB('-0.008815115317702293, 0.019053427502512932, 0.009444420225918293, 0.014861286617815495, 0.024126596748828888, -0.04732375964522362, -0.05657938867807388, 0.000339764344971627, 0.008374601602554321, -0.00590578792616725, -0.018414441496133804, -0.002660025143995881, 0.016691112890839577, 0.029606394469738007, 0.0026455025654286146, 0.027031082659959793, -0.04631686955690384, -0.01824985444545746, 0.0038605460431426764, -0.04197950288653374, -0.0018588710809126496, 0.0125376982614398, 0.04794338345527649, -0.011966481804847717, 0.007861475460231304, 0.0007836061413399875, -0.0011611892841756344, 0.006176873575896025, 0.0074838921427726746, -0.012431199662387371, 0.006259167101234198, 0.001208387198857963, -0.024804310873150826, -0.014522429555654526, 0.023565063253045082, -0.007266055792570114, 0.004378512501716614, -0.013079868629574776, 0.011927755549550056, -0.023352067917585373, 0.013312227092683315, 0.028309056535363197, 0.00012570979015436023, 0.030361559242010117, 0.009521872736513615, -0.01799813099205494, -0.05534014105796814, -0.016061807051301003, 0.0013711594510823488, -0.005063487216830254, -0.030652008950710297, -0.029877478256821632, -0.007750136777758598, 0.04217313602566719, 0.0023719968739897013, -0.015742313116788864, -0.017078377306461334, -0.004499532748013735, -0.023139070719480515, 0.013738218694925308, -0.0216481015086174, -0.006273689679801464, 0.012382792308926582, 0.008137401193380356, -0.016390983015298843, -0.01728169247508049, 0.017223602160811424, -0.001148482202552259, -0.0058961063623428345, -0.026256553828716278, -0.008849000558257103, -0.014125483110547066, -0.029161039739847183, 0.018240172415971756, 0.00878122914582491, 0.01732041873037815, -0.028405873104929924, -0.02683744952082634, -0.06006477028131485, 0.008868363685905933, -0.00399608863517642, -0.012595787644386292, 0.00769204692915082, -0.028638232499361038, -0.003855705028399825, 0.023894237354397774, -0.024901125580072403, 0.010310925543308258, -0.051970936357975006, 0.01435784250497818, -0.01591658405959606, 0.019508464261889458, -0.03285941854119301, -0.006041330751031637, 0.030671371147036552, 0.05104149878025055, 0.01255706138908863, -0.0062882122583687305, 0.012818465009331703, -0.024726856499910355, 0.05731518939137459, -0.0006389869377017021, 0.0019919932819902897, 0.0009754232014529407, -0.017262328416109085, -0.026895539835095406, 0.025385206565260887, -0.011085454374551773, -0.002994040958583355, 0.009153971448540688, -0.01868552714586258, -0.000645643041934818, -0.00016625157149974257, -0.01013665646314621, 0.03874584287405014, -0.014454658143222332, -0.03628671169281006, -0.002827032934874296, 0.03163953498005867, -0.040740255266427994, -0.0026358210016041994, 0.009981750510632992, -0.03481510654091835, 0.02792179211974144, -0.02402978017926216, -0.00037425511982291937, -0.008166446350514889, 0.05073168873786926, 0.04318002611398697, -0.0490664504468441, -0.0382423996925354, 0.009313718415796757, 0.026469549164175987, 0.007938927970826626, 0.021086568012833595, 0.07114054262638092, 0.017078377306461334, 0.003514427924528718, 0.026062920689582825, -0.009705823846161366, 0.013496178202331066, -0.02193855121731758, -0.019789231941103935, 0.054526884108781815, -0.026237189769744873, -0.01854030229151249, 0.022713080048561096, -0.004693165421485901, -0.05475924164056778, -0.02695363014936447, 0.023100344464182854, 0.012886236421763897, 0.0010474302107468247, -0.001958107575774193, 0.010310925543308258, 0.046045783907175064, -0.006772293243557215, -0.04000445455312729, -0.03233661130070686, 0.0064140730537474155, 0.05108022689819336, -0.01536473073065281, 0.012682922184467316, -0.03402121365070343, 0.021686827763915062, -0.02207409404218197, -0.012731330469250679, -0.002218301175162196, 0.01433847937732935, -0.002427666215226054, -0.01159858051687479, -0.010214108973741531, -0.011046728119254112, -0.02445577271282673, 0.041398607194423676, -0.022751806303858757, -0.005257119424641132, -0.0055717723444104195, 0.0609167516231536')
||TO_CLOB('87, -0.025443296879529953, -0.017039651051163673, 0.017901314422488213, -0.000878001912496984, 0.004477749112993479, -0.0019399545853957534, -0.002529323101043701, 0.03332413733005524, 0.032123614102602005, 0.009337922558188438, -0.021667465567588806, 0.02035076543688774, -0.007450006436556578, 0.0068400646559894085, -0.0062688491307199, 0.02980002574622631, 0.0250753965228796, -0.00862148217856884, 0.0037080603651702404, 0.027689432725310326, 0.009865570813417435, -0.0028657594230026007, 0.039559099823236465, 0.02641145884990692, -0.045542340725660324, 0.0010649781906977296, 0.010882141068577766, -0.03022601827979088, 0.04108879342675209, -0.011966481804847717, -0.0015526898205280304, 0.009700982831418514, 0.02879313752055168, -0.00011096044181613252, 0.019498782232403755, 0.016255440190434456, 0.028522051870822906, -0.03272387385368347, -0.018927566707134247, -0.03921056166291237, 0.028812501579523087, 0.051312584429979324, -0.0328400544822216, -0.03148462623357773, 0.021803008392453194, 0.005634702742099762, -0.013031460344791412, 0.004388194065541029, -0.0016386142233386636, 0.003935578279197216, -0.000111792454845272, 0.009671938605606556, 0.03557027131319046, 0.024300865828990936, 0.03477637842297554, -0.006230122409760952, 0.03984954580664635, 0.04043044522404671, 0.002882702276110649, 0.008045426569879055, -0.005746041424572468, 0.008853841572999954, 0.04895026981830597, 0.015161416493356228, 0.010097929276525974, -0.011753486469388008, -0.005954196210950613, 0.00379761541262269, -0.032665785402059555, 0.021202746778726578, 0.03088436834514141, -0.003700799308717251, 0.03305305168032646, -0.009822003543376923, 0.04372219741344452, 0.0046447571367025375, -0.03227851912379265, 0.027282804250717163, 0.05793481320142746, -0.004051757976412773, -0.020583124831318855, -0.009555758908390999, 0.04623941704630852, -0.034466568380594254, 0.00477061839774251, 0.0007521408260799944, -0.002761682029813528, 0.021086568012833595, 0.018462849780917168, 0.0022727602627128363, 0.02983875200152397, 0.014657972380518913, -0.015442184172570705, -0.008611801080405712, -0.005470115225762129, -0.00961384829133749, -0.005716996733099222, 0.01421261765062809, 0.006544774863868952, 0.004925524350255728, 0.01857902854681015, -0.013718855567276478, 0.023758694529533386, 0.00997206848114729, -0.02344888262450695, -0.019469738006591797, 0.06126528978347778, -0.02102847769856453, 0.005136099178344011, 0.003613664535805583, 0.042328041046857834, -0.02947085164487362, 0.027360258623957634, -0.021493196487426758, 0.010272198356688023, -0.007905042730271816, -0.0029432123992592096, -0.02131892740726471, 0.012653877027332783, -0.021803008392453194, -0.010465831495821476, 0.011433993466198444, -0.014415931887924671, 0.0008773967856541276, -0.009308877401053905, -0.0082100136205554, 0.002065815730020404, 0.0005061671836301684, -0.026140373200178146, 0.03235597535967827, 0.002851237077265978, -0.022461358457803726, 0.010146337561309338, -0.025656292214989662, -0.015393775887787342, 0.031194180250167847, 0.019827958196401596, -0.02337143011391163, 0.012731330469250679, -0.019053427502512932, -0.0026672862004488707, 0.010959593579173088, -0.005504000931978226, 0.01598435454070568, -0.021105932071805, 0.032375335693359375, 0.043528564274311066, -0.0008568233461119235, 0.0068981540389359, -0.021415743976831436, -0.011230679228901863, -0.052474379539489746, -0.004676222335547209, 0.013922169804573059, 0.03384694457054138, 0.017146149650216103, 0.04910517483949661, -0.006278530694544315, 0.020621851086616516, -0.02550138719379902, -0.01255706138908863, -0.027611980214715004, -0.002638241508975625, 0.01536473073065281, -0.018966292962431908, 0.010252835229039192, -0.0125376982614398, -0.008907089941203594, 0.011211316101253033, 0.027476437389850616, 0.010698189958930016, 0.013728536665439606, 0.03779704496264458, -0.004429341293871403, -0.014870968647301197, -0.021415743976831436, -0.06273689866065979, 0.023603789508342743, -0.009531554765999317, -0.003366783261299')
||TO_CLOB('1333, 0.01644907146692276, 0.006869109347462654, 0.006990129593759775, -0.027786249294877052, 0.03665461391210556, 0.010814369656145573, 0.018666163086891174, -0.005320050287991762, -0.010301243513822556, -0.011869666166603565, 0.02662445418536663, -0.001976260682567954, 0.003800035919994116, -0.009913979098200798, -0.007411280181258917, -0.0111822709441185, 0.023797422647476196, 0.03988827392458916, 0.0012610310222953558, -0.02009904384613037, -0.005867061670869589, -0.010146337561309338, -0.04678158834576607, 0.02139637991786003, 0.049879707396030426, 0.009313718415796757, 0.048137012869119644, 0.0155099555850029, 0.007280578371137381, 0.02879313752055168, 0.01237311027944088, 0.010097929276525974, 0.002836714731529355, -0.008916771970689297, 0.0069659254513680935, -0.0030884367879480124, -0.0033837261144071817, 0.027050446718931198, -0.027766885235905647, -0.025520749390125275, -0.008118038065731525, 0.015277596190571785, -0.023022891953587532, 0.007508096285164356, 0.007967973127961159, -0.01122099719941616, -0.022887349128723145, -0.00041267904452979565, -0.03274323791265488, 0.013157321140170097, -0.02918040193617344, -0.02524966560304165, -0.02929658256471157, 0.002461551921442151, -0.023352067917585373, -0.00899906549602747, -0.0017160670831799507, 0.010417423211038113, -0.006941721308976412, -0.042405493557453156, 0.01644907146692276, -0.0335371308028698, 0.016061807051301003, -0.04728503152728081, 0.0160521250218153, -0.02511412277817726, 0.03357585892081261, 0.03938483074307442, 0.02244199439883232, 0.02377805858850479, -0.011104818433523178, -0.018598392605781555, 0.010736916214227676, 0.0020065156277269125, -0.012450562790036201, 0.002616457873955369, -0.0068981540389359, 0.04786592721939087, -0.011211316101253033, 0.0055427271872758865, 0.05704410374164581, -0.022132182493805885, -0.011211316101253033, -0.02708917297422886, 0.001811673166230321, -0.015674542635679245, -0.026934266090393066, 0.03909438103437424, 0.020466944202780724, -0.03539600223302841, -0.023255251348018646, 0.009003906510770321, -0.01017538271844387, -0.002476074267178774, 0.043993279337882996, -0.0008047846495173872, 0.02348761074244976, -0.007730773650109768, -0.0038702276069670916, 0.03804876655340195, 0.0027665228117257357, 0.006075216457247734, 0.003100538859143853, 0.011908392421901226, 0.03477637842297554, -0.02838650904595852, -0.000353379116859287, 0.011850303038954735, -0.004129210952669382, -0.010959593579173088, -0.01979891210794449, 0.021686827763915062, -0.011250042356550694, 0.012992734089493752, -0.010243154130876064, 0.015538999810814857, -0.007566186133772135, 0.024765584617853165, -0.017698001116514206, -0.01619734987616539, 0.010039839893579483, 0.00478998152539134, 0.005334572400897741, -0.04488398879766464, -0.016497479751706123, 0.004581826739013195, 0.011569535359740257, 0.007343508768826723, -0.014231981709599495, -2.0422166926437058e-05, 0.039559099823236465, -0.00309327756986022, 0.007382235024124384, 0.008887726813554764, -0.017465641722083092, -0.0025777313858270645, 0.02106720581650734, 0.03574454039335251, 0.011153225786983967, -0.009463783353567123, -0.013070186600089073, 0.018278898671269417, 0.008093833923339844, 0.02828969433903694, -0.03444720432162285, -0.026140373200178146, -0.005305527709424496, -0.07001747190952301, 0.0033522609155625105, -0.030826278030872345, 0.010117292404174805, 0.013757581822574139, 0.003006143029779196, 0.01832730695605278, -0.0357058160007, -0.03359522297978401, 0.03287878260016441, -0.011569535359740257, -0.040856435894966125, -0.011540491133928299, -0.0076387980952858925, -0.032917506992816925, 0.011753486469388008, -0.005073168780654669, -0.015538999810814857, 0.006317256949841976, -0.011627625674009323, 0.01341872476041317, -0.008088993839919567, -0.019721459597349167, -0.046161964535713196, 0.04217313602566719, 0.02997429482638836, -0.004163096658885479, -0.02366187982261181, -0.0034369751811027527, 0.024630041792988777, 0.015926264226436615, 0.0022231419570744038, -0.0116469')
||TO_CLOB('88801658154, 0.006932039745151997, -0.02983875200152397, 0.021338289603590965, 0.006191396154463291, -0.008118038065731525, -0.026682544499635696, 0.015645498409867287, 0.0267019085586071, -0.00956059992313385, -0.007803385611623526, 0.010853095911443233, -0.009696142747998238, -0.020796120166778564, 0.00400334969162941, -0.004209084436297417, 0.0028706002049148083, 0.009734869003295898, 0.004378512501716614, 0.015674542635679245, 0.029025496914982796, 0.004540679976344109, 0.0007200705003924668, -0.0070433784276247025, 0.041359879076480865, 0.029664482921361923, 0.004608450923115015, 0.02550138719379902, 0.005058646202087402, -0.001401414512656629, 0.028115423396229744, 0.013951214030385017, 0.017000924795866013, 0.03314986824989319, 0.01872425340116024, -0.030865004286170006, -0.005581453908234835, 0.014929058030247688, 0.007725932635366917, 0.018956610932946205, -0.008902249857783318, -0.040740255266427994, 0.005784767679870129, -0.01706869527697563, -0.008239058777689934, -0.0026091965846717358, 0.05425579845905304, -0.036383528262376785, 0.025849925354123116, -0.00038060868973843753, -0.004293798469007015, -0.03361458331346512, -0.014057711698114872, 0.014270707964897156, -0.024610677734017372, 0.0005185717600397766, 0.022829260677099228, -0.03595753759145737, 0.03729360178112984, -0.02737962082028389, 0.024378318339586258, 0.029432125389575958, 0.006738407537341118, 0.03777768090367317, 0.006118783727288246, -0.008297148160636425, 0.0012186738895252347, -0.029606394469738007, 0.021047841757535934, -0.02821223996579647, -0.03466019779443741, 0.01094991248100996, 0.0005215972778387368, -0.03369203582406044, -0.0013203308917582035, 0.008456895127892494, 0.015374412760138512, -0.00340066896751523, -0.010330288670957088, -0.0026987516321241856, -0.026488911360502243, 0.013660766184329987, -0.024358956143260002, -0.00862148217856884, 0.0018963873153552413, 0.00519418902695179, -0.0027786248829215765, 0.021764282137155533, -0.0026914903428405523, 0.035008735954761505, -0.029993658885359764, -0.0021819951944053173, 0.005087691359221935, -0.014638609252870083, 0.009623530320823193, -0.02590801566839218, -0.012431199662387371, -0.01832730695605278, 0.011511445976793766, -0.0007134143961593509, 0.00407838262617588, -0.023003529757261276, -0.014222299680113792, -0.04019808769226074, -0.02139637991786003, 0.035550907254219055, -0.028367146849632263, -0.020834846422076225, 0.01475478895008564, -0.02048630826175213, -0.013157321140170097, -0.003313534427434206, -0.059290241450071335, 0.0003061812312807888, -0.01096927560865879, 0.010678826831281185, 0.021803008392453194, -0.049724798649549484, -0.02031203918159008, -0.005794449709355831, 0.020505670458078384, 0.044457998126745224, -0.017765773460268974, -0.007880838587880135, 9.530344686936587e-05, 0.031116725876927376, -0.0011841831728816032, 0.03378885239362717, 0.03328540921211243, 0.011859984137117863, 0.0007708990015089512, -0.01093054935336113, -0.02950957790017128, -0.010746598243713379, -0.007425802294164896, -0.0007557714707218111, 0.0003697168722283095, 0.006157510448247194, -0.01821112632751465, 0.02395232766866684, -0.003226399887353182, 0.0001266930776182562, -0.020079679787158966, 0.008713457733392715, 0.0028657594230026007, 0.00999143160879612, -0.008897408843040466, 0.011414630338549614, -0.0015696326736360788, -0.004429341293871403, -0.04228931665420532, 0.0019387444481253624, -0.00011421286035329103, 0.010243154130876064, -0.01652652584016323, -0.05545631796121597, -0.022538810968399048, 0.004627814516425133, -0.018811387941241264, 0.006956243887543678, -0.02265498973429203, -0.020505670458078384, -0.03177507594227791, 0.04484526440501213, 0.014948421157896519, -0.0023235888220369816, 0.009797799400985241, 0.029432125389575958, -0.006051012314856052, -0.005838016979396343, 0.003877488896250725, 0.003775831777602434, 0.02294543944299221, -0.02662445418536663, 0.015577726066112518, -0.007145035546272993, 0.03314986824989319, 0.004095325246453285, -0.003654811531305313, ')
||TO_CLOB('0.025404570624232292, 0.004724630620330572, -0.004356728866696358, -0.015703586861491203, 0.029935568571090698, -0.005779927130788565, -0.015316322445869446, -0.012072980403900146, 0.017146149650216103, -0.012344065122306347, -0.011443674564361572, -0.016933152452111244, 0.0041267904452979565, 0.014444977045059204, 0.031910620629787445, -0.005828335415571928, -0.01237311027944088, -0.036809518933296204, -0.016255440190434456, -0.009749391116201878, -0.0007963132229633629, 0.026179099455475807, 0.043954554945230484, 0.023390794172883034, -0.02575310878455639, -0.03148462623357773, 0.0022473460994660854, -0.011250042356550694, 0.028948044404387474, 0.027805613353848457, 0.026217827573418617, 0.006694840267300606, 0.0026648659259080887, -0.02135765366256237, 0.10161828249692917, -0.02708917297422886, -0.014599882997572422, -0.02207409404218197, 0.010591692291200161, 0.024901125580072403, 0.004891638644039631, 0.03483446687459946, 0.016574934124946594, -0.0035604157019406557, 0.027302168309688568, -0.06269817054271698, 0.03648034483194351, 0.018240172415971756, -0.020796120166778564, -7.157213076425251e-06, 0.004485010635107756, -0.027979882434010506, 0.006525411736220121, -0.005000556819140911, 0.028657594695687294, -0.018240172415971756, -0.036596521735191345, -0.01933419518172741, 0.006399550940841436, -0.011356540024280548, 0.012731330469250679, -0.015451865270733833, -0.028483325615525246, 0.0035725177731364965, -0.0158681757748127, 0.016390983015298843, -0.00253900489769876, -0.010039839893579483, -0.012198841199278831, 0.016642704606056213, 0.0071643986739218235, 0.035976897925138474, -0.009943023324012756, 0.014270707964897156, 0.0036402891855686903, 0.0044027166441082954, -0.0009185436647385359, -0.002684229053556919, -0.024087870493531227, -0.007967973127961159, 0.00037001940654590726, -0.020679939538240433, -0.016981560736894608, 0.012179478071630001, 0.027863701805472374, 0.0067674522288143635, 0.027302168309688568, -0.014822560362517834, 0.023468246683478355, 0.010039839893579483, -0.01897597499191761, -0.023584425449371338, -0.012566742487251759, -0.025191575288772583, 0.02323588728904724, -0.006428595632314682, 0.006346301641315222, -0.007454847451299429, -0.00793408788740635]')
```

上の実験ではこの出力結果を SQL クエリに組み込みました。

## 参考） メモリの使用量

上記の手順では CDB のベクトル・プールのサイズを設定していますが、この際には全ての PDB のベクトル・プールのサイズが同じ値に設定されます。各 PDB で上限値を決めたい場合には、このパラメータの値を変更します。

```sql
alter session set container=freepdb1;
show parameter vector_memory_size
```
```
NAME               TYPE        VALUE 
------------------ ----------- ----- 
vector_memory_size big integer 304M
```

v$vector_memory_pool ビューを確認すると、索引が格納される「1MB プール」に（304MB のうちの）208MB が割り当てられていることがわかります。

```sql
select
  con_id, pool,
  alloc_bytes/1024/1024 as alloc_bytes_mb,
  used_bytes/1024/1024 as used_bytes_mb
from v$vector_memory_pool order by 1,2;
```
```
CON_ID POOL 		      ALLOC_BYTES_MB USED_BYTES_MB
------ ------------------ -------------- -------------
	 3 1MB POOL				         208           161
	 3 64KB POOL				      80        0.9375
	 3 IM POOL METADATA			      16            16
```

HNSW 索引はメモリを多く消費するため、見積りした上でメモリ容量を決める必要がありそうです。