From ede9a45c24f4b987215986d16d934a4b9fd0af8c Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Fri, 5 Jul 2024 14:43:55 +0300 Subject: Fix typo. Signed-off-by: Munyoki Kilyungi --- topics/engineering/improving-wiki-rif-search-in-genenetwork.gmi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'topics/engineering') diff --git a/topics/engineering/improving-wiki-rif-search-in-genenetwork.gmi b/topics/engineering/improving-wiki-rif-search-in-genenetwork.gmi index ec2e45f..d0f1978 100644 --- a/topics/engineering/improving-wiki-rif-search-in-genenetwork.gmi +++ b/topics/engineering/improving-wiki-rif-search-in-genenetwork.gmi @@ -33,7 +33,7 @@ running an "EXPLAIN" on [0] yields: +------+-------------+----------------+--------+-----------------------------+------------------+---------+------------------------------------------------------------+-------+-------------+ ``` -From the above table, we note that we have "ref" under the "type" column in on line 9. The "type" column describes how the rows are found from the table (I.e the join type) [2]. In this case, "ref" means a non-unique index or prefix is used to find all the rows which we can see by running "SHOW INDEXES FROM ProbeSetXRef" (note the Non-unique value of 1 for ProbeSetFreezeId): +From the above table, we note that we have "ref" under the "type" column in line 9. The "type" column describes how the rows are found from the table (I.e the join type) [2]. In this case, "ref" means a non-unique index or prefix is used to find all the rows which we can see by running "SHOW INDEXES FROM ProbeSetXRef" (note the Non-unique value of 1 for ProbeSetFreezeId): ``` +--------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ -- cgit v1.2.3