From 7363d83b6df50f6cd31f15aebe2ace95d13a2e00 Mon Sep 17 00:00:00 2001 From: Alex Tatiyants Date: Wed, 6 Jan 2016 21:33:50 -0800 Subject: improve syntax highlighting --- app/services/help-service.ts | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'app/services/help-service.ts') diff --git a/app/services/help-service.ts b/app/services/help-service.ts index 8859c24..0195aff 100644 --- a/app/services/help-service.ts +++ b/app/services/help-service.ts @@ -12,11 +12,14 @@ export var NODE_DESCRIPTIONS = { "NESTED LOOP": `merges two record sets by looping through every record in the first set and trying to find a match in the second set. All matching records are returned.`, "MERGE JOIN": `merges two record sets by first sorting them on a join key.`, + "HASH": `generates a hash table from the records in the input recordset. Hash is used by + Hash Join.`, + "HASH JOIN": `joins to record sets by hashing one of them (using a Hash Scan).`, "AGGREGATE": `groups records together based on a GROUP BY or aggregate function (like sum()).`, "HASHAGGREGATE": `groups records together based on a GROUP BY or aggregate function (like sum()). Hash Aggregate uses a hash to first organize the records by a key.`, - "SEQ SCAN": `finds relevant records by sequentially scanning the table. Seq Scans perform a single read operation - (only the table is read).`, + "SEQ SCAN": `finds relevant records by sequentially scanning the input record set. When reading from a table, + Seq Scans (unlike Index Scans) perform a single read operation (only the table is read).`, "INDEX SCAN": `finds relevant records based on an Index. Index Scans perform 2 read operations: one to read the index and another to read the actual value from the table.`, "INDEX ONLY SCAN": `finds relevant records based on an Index. Index Only Scans perform a single read operation -- cgit v1.2.3