Recently I have been working with some tables that have a CLOB column , containing an XML export of a query containing some 11k+ rows by 20 columns. When querying the table the performance is terrible, the window goes unresponsive multiple times and I have to keep telling it to keep waiting before it will render the table results. Even once rendered navigating the result is terrible from a performance perspective.
In contrast, some of our team use Quest Toad for Oracle. For them the table results for the column just say CLOB… for the column. Only when viewing a single record does it load the CLOB content, and then it's only for that single record. For them the table query returns MUCH faster and navigation is much snappier because the table results aren't trying to load 200+ CLOB columns with massive (by single row terms) data sets.
I am by no means pushing for a ‘Toad does this so Oracle should too’ situation. This is simply a terrible experience in the current VS Code extension but managed much better in other alternatives.
It would be ideal if we could get a setting in the VS Code extension to toggle an option where CLOB content is only loaded in single record view. In table view, it be replaced by some placeholder.