Sybase SQL Anywhere extended attributes

Chapter 12 DBMS-Specific Features

Sybase SQL Anywhere extended attributes

The following extended attributes are defined by default in the Sybase SQL Anywhere DBMS.

Columns

The following extended attributes are available on the Sybase tab:

Name	Description
Column is compressed	Specifies whether this column is stored in a compressed format. Scripting name: Compressed

Tables

The following extended attributes are available on the Sybase tab:

Name	Description
PCTFREE	Specifies the percentage of free space you want to reserve for each table page. The free space is used if rows increase in size when the data is updated. If there is no free space in a table page, every increase in the size of a row on that page requires the row to be split across multiple table pages, causing row fragmentation and possible performance degradation. The value percent-free-space is an integer between 0 and 100. The former specifies that no free space is to be left on each page (each page is to be fully packed). A high value causes each row to be inserted into a page by itself. If PCTFREE is not set, 200 bytes are reserved in each page. Scripting name: PctFree
Temporary table	Specifies either temporary table is a global or a local temporary table. Scripting name: TemporaryTable

Name

Description

PCTFREE

Specifies the percentage of free space you want to reserve for each table page. The free space is used if rows increase in size when the data is updated. If there is no free space in a table page, every increase in the size of a row on that page requires the row to be split across multiple table pages, causing row fragmentation and possible performance degradation.

The value percent-free-space is an integer between 0 and 100. The former specifies that no free space is to be left on each page (each page is to be fully packed). A high value causes each row to be inserted into a page by itself. If PCTFREE is not set, 200 bytes are reserved in each page.

Scripting name: PctFree

Temporary table

Specifies either temporary table is a global or a local temporary table.

Scripting name: TemporaryTable

Indexes

The following extended attributes are available on the Sybase tab:

Name	Description
Virtual index	The VIRTUAL keyword is primarily for use by the Index Consultant. A virtual index mimics the properties of a real physical index during the evaluation of query plans by the Index Consultant and when the PLAN function is used. You can use virtual indexes together with the PLAN function to explore the performance impact of an index, without the often time consuming and resource consuming effects of creating a real index. Scripting name: Virtual

Name

Description

Virtual index

The VIRTUAL keyword is primarily for use by the Index Consultant. A virtual index mimics the properties of a real physical index during the evaluation of query plans by the Index Consultant and when the PLAN function is used. You can use virtual indexes together with the PLAN function to explore the performance impact of an index, without the often time consuming and resource consuming effects of creating a real index.

Scripting name: Virtual

Web Services

The following extended attributes are available on the Sybase tab:

Name	Description
Port number	Specifies the web service port number. Scripting name: PortNumber
Server name	Specifies the web service server name. Scripting name: ServerName
Name prefix	[DISH service type] Specifies a name prefix. Only SOAP services whose names begin with this prefix are handled. Scripting name: Prefix

Web Operations

The following extended attributes are available on the Sybase tab when the service type is not dish:

Name	Description
URL	Determines whether URI paths are accepted and, if so, how they are processed. Scripting name: Url