Hi Qiao,
You can also send us the DDL and the query plan to help with the tuning.
To generate a query plan, do the following from sqlci, and the plan is in
text file mylog.
1. log mylog clear;
2. prepare xx from ;
3. explain xx;
4. explain options 'f' xx;
5. exit;
Thanks
Hello Qiao,
When you say whatever the table ddl it limits things a lot, as table ddl
will help define several things that will drastically improve the degree of
parallelism and the table size.
The DOP (degree of parallelism) of the scan operator is constrained by the
number of regions your table
Hi, Forling,
You can try to search in the system metadata, here is an example
select ROW_TOTAL_LENGTH , ROW_DATA_LENGTH from "_MD_".tables , "_MD_".objects
where “_MD_”.objects.OBJECT_UID = “_MD_”.tables.table_uid and
objects.OBJECT_NAME='your_table_name’;
and you can check other columns in