SqlStatement Element for SubscriptionClass/IndexSqlSchema (ADF)
Contains a Transact-SQL statement that creates a SQL Server index for the subscription table.
Syntax
<SubscriptionClasses>
<SubscriptionClass>
...
<IndexSqlSchema>
<SqlStatement>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string, between 1 and 100,000 characters in length. |
Default value |
None. |
Occurrence |
Optional once or more per IndexSqlSchema element. |
Updates |
Can be added, deleted, and modified when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
If you add, delete, or update the indexing SqlStatement element, updating the application deletes and re-creates the subscription class to which it corresponds. This includes dropping and re-creating the SQL Server tables and indexes used by this subscription class. Any data existing in the original SQL Server tables is permanently deleted.
Example
The following example shows a SqlStatement element that creates an index on the StockSubscriptions table.
<SqlStatement>
CREATE INDEX StockSubIndex
ON StockSubscriptions (SubscriberId);
</SqlStatement>
See Also
Reference
Application Definition File Reference
Other Resources
Defining Indexes for a Subscription Class
Updating Instances and Applications