[citation needed] This penalty can be minimized in solutions that periodically do a batched TRIM, rather than trimming upon every file deletion, by scheduling such batch jobs for times when system utilization is minimal. This TRIM shortcoming has been overcome in Serial ATA revision 3.1 with the introduction of the Queued TRIM Command.
https://en.wikipedia.org/wiki/Trim_(computing)
TRIM Function Removes leading characters, trailing characters, or both from a character string.
http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/n1x15ai82patq8n1v4xryc1phpdr.htm
If you specify LEADING, Oracle removes any leading characters equal to trim_character. 1  If you specify TRAILING, Oracle removes any trailing characters equal to trim_character. 2  If you specify BOTH or none of the three, Oracle removes leading and trailing characters equal to trim_character. If you do not specify trim_character, the default value is a blank space. If you specify only trim_source, Oracle removes leading and trailing blank spaces. The function returns a value with datatype VARCHAR2. The maximum length of the value is the length of trim_source. If either trim_source or trim_character is a null value, then the TRIM function returns a null value. Both trim_character and trim_source can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 datatype and is in the same character set as trim_source.
http://www.toadworld.com/platforms/oracle/w/wiki/3788.trim-function-trimmg
The TRIM function is useful for trimming character strings of blanks or other characters before they are concatenated.
http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/n1x15ai82patq8n1v4xryc1phpdr.htm
There are different types of TRIM defined by SATA Words 69 and 169 returned from an ATA IDENTIFY DEVICE command: Non-deterministic TRIM: Each read command to the Logical block address (LBA) after a TRIM may return different data. Deterministic TRIM (DRAT): All read commands to the LBA after a TRIM shall return the same data, or become determinate. Deterministic Read Zero after TRIM (RZAT): All read commands to the LBA after a TRIM shall return zero.
https://en.wikipedia.org/wiki/Trim_(computing)
TRIM is available with RAID volumes in post-January-2011 releases of the Linux kernel's dmraid, which implements BIOS-assisted fake hardware RAID support, and which now passes through any TRIM requests from the filesystem that sits on the RAID array.
https://en.wikipedia.org/wiki/Trim_(computing)
Trim (computing) A trim command (known as TRIM in the ATA command set, and UNMAP in the SCSI command set) allows an operating system to inform a solid-state drive (SSD) which blocks of data are no longer considered in use and can be wiped internally. Trim was introduced soon after SSDs were introduced.
https://en.wikipedia.org/wiki/Trim_(computing)
Enclose a literal character in single quotation marks. If trim-character is not specified, the TRIM function trims all blank spaces, not just one character.
http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/n1x15ai82patq8n1v4xryc1phpdr.htm
TRIM Function (TRIMMG) New in Oracle8i is the implementation of the ANSI-standard TRIM function. TRIM enables you to trim ing or trailing characters (or both) from a character string. If trim_character or trim_source is a character literal, you must enclose it in single quotes. 1  If you specify LEADING, Oracle removes any leading characters equal to trim_character. 2  If you specify TRAILING, Oracle removes any trailing characters equal to trim_character.
http://www.toadworld.com/platforms/oracle/w/wiki/3788.trim-function-trimmg
As of January 2017, support for the TRIM command is not implemented in most hardware-based RAID technologies. However, software RAID implementations often do include support for TRIM. Windows: Windows 10 offers support for TRIM in SSD RAID volumes using the optimize drives option when configuring a RAID volume. Mac OS:
https://en.wikipedia.org/wiki/Trim_(computing)
what is the trim function doing
The TRIM function is useful for trimming character strings of blanks or other characters before they are concatenated.