on 31-07-202008:40 PM - edited on 14-10-202010:42 AM by exa-Vandana
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 data for the query in question, if possible also profiling data of a similar query that gives better results.
How to get a profiling data for Exasol support?
Execute the following steps:
Obtain the SQL text of the query in question
Open a new database connection, typically using EXAplus
Execute the following:
set autocommit on;
alter session set profile='on';
<your query here>;
alter session set profile='off';
alter session set NLS_NUMERIC_CHARACTERS='.,';
alter session set NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH:MI:SS.ff3';
where session_id = current_session
into LOCAL CSV
Attach the generated CSV file to your support ticket.