Date: Fri, 29 Mar 2024 02:49:00 -0700 (PDT) Message-ID: <913981753.493.1711705740942@wiki.srpcs.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_492_835506471.1711705740941" ------=_Part_492_835506471.1711705740941 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Updates or rebuilds indexes in a specified column or for all columns in = an attached table.
Update_Index (table_name, column_name, rebuild= flag)
Parameters are as follows.
Parameter | Description |
---|---|
table_name | The name of the table whose indexes are updated = or rebuilt. If table_name is null, and rebuildflag is fa= lse (0) or null, all indexes for all attached tables are updated. |
column_name | Update or rebuild all indexes for the specified = column. If column_name is null, and rebuildflag is false= (0) or null, all indexes for table_name are updated. If column_name is nul= l, and rebuildflag is True (1), all indexes for table_name are rebuilt. |
rebuildflag | If rebuildflag is true (1), i= ndexes are rebuilt. |
The table_name contains a system delimiter.
Create_Index,&= nbsp;Delete_Index= , List_Index
/* Updates the ind= ex on the PART_NAME column in the CAR_PARTS table. */ Call Update_Index ("CAR_PARTS", "PART_NAME", "") /* Rebuilds indexes on the PART_NAME column in the CAR_PARTS table. */ Call Update_Index ("CAR_PARTS", "PART_NAME", "1")