db_table_sort_order
You can run the db_table_sort_order script to obtain the percentage of the data sorted on the filesystem with the help of the synopsis table.
Usage
db_table_sort_order [-h] [-host HOST] [-db DB] [-dsn DSN] [-schema SCHEMA] -table TABLE [-column COLUMN] [-user USER] [-pw PW]Generic command option
- -h|--help
- Displays help for the command.
Required arguments
- -table TABLE
- Specifies the table for which the statistics are being looked up.
Optional arguments
- -host HOST
- Specifies the hostname of which you want to obtain details.
- -db DB
- Specifies the database for which you want to obtain statistics. The default is
BLUDB. - -dsn DSN
- An alternative to the -host and -db options.
- -schema SCHEMA
- Specifies the schema under which the table exists. If not specified, it considers all user-defined schemas as tables that reside under it. The -table parameter is ignored.
- -column COLUMN
- Displays details for a particular column or columns.
- -user USER
- Specifies the database user.
- -pw PW
- Specifies the database password.