User Activity

Question Knowing that JOINS on VARCHAR of various sizes can create an expression index, what about using datatype DECIMAL? Answer Before we go into detail, a few things to keep in mind: Joins between columns of the same datatype will build an index t...
Problem JSON data that is stored in EXASOL tables can be accessed through UDFs. JSON documents can be accessed through path expressions. To understand what path expressions are, let us have a look at the following JSON document: { "name": "Bob", "age...
Background Cause and Effect: Since EXASolution transaction isolation level is SERIALIZABLE and newly created transactions are automatically scheduled after finished transactions, it is possible that WAIT FOR COMMITS occur for pure read transactions (...
Background Verifying the environment your DB client is accessing can sometimes be tricky. Where do I find what version of Exasol am I running? Which user am I running as? We have a solution canned up to get you started and introduce you to the power ...
Background Query behavior is unexpected Sometimes EXASolution exhibits unexpected behavior when executing queries. Analyzing "this is slow" in support is impossible without additional information. The single foremost information we need is profiling ...
This widget could not be displayed.
This widget could not be displayed.
Kudos given to