更新日期：2024年09月11日
使用 SET INDEXES 语句来启用或禁用用户定义的索引，或更改唯一索引的过滤
模式。
GBase 8s SQL 指南：语法
南大通用数据技术股份有限公司 1048
此语句是对 SQL 的 ANSI/ISO 标准的扩展。
语法
元素
描述
限制
语法
index 要启用、禁用或更改它的过滤模式的索引 必须存在 标识符
table
要全部启用、禁用或更改其索引的过滤模
式的表
必须存在 标识符
用法
您可使用此语句来启用或禁用特定的索引或索引的列表。您还可使用 table 选项
来在未指定其单个标识符的表上启用或禁用所有用户定义的索引。例如，以下两
个示例分别地禁用和启用 cust_calls 表上的所有索引：
SET INDEXES FOR cust_calls DISABLED;
SET INDEXES FOR cust_calls ENABLED;
在您打算 LOAD 或 TRUNCATE 表中的所有数据，或合并表中的空闲空间的地
方，此简单的语法可便于操作。
显式定义的索引和隐式定义的索引
SET INDEXES 语句对 CREATE INDEX 语句显式地创建的索引进行操作。然
而，这对 PRIMARY KEY 或 FOREIGN KEY 约束定义显式地创建的系统定义的
索引不起作用。SET INDEXES 语句不可指定以空格（ASCII 32）字符开头的系统
生成的名称，即使您的数据库有 DELIMIDENT 环境变量设置来支持双引号作为
数据库对象标识符的定界符。
要启用或禁用隐式定义的索引，请改为使用 SET CONSTRAINTS 语句，其 FOR
table 选项可隐式地引用系统生成的约束，如下例中所示：
SET CONSTRAINTS FOR cust_calls DISABLED;
GBase 8s SQL 指南：语法
南大通用数据技术股份有限公司 1049
SET CONSTRAINTS FOR cust_calls ENABLED;
要禁用表的所有显式定义的索引和隐式定义的索引，请同时使用 SET INDEXES
和 SET CONSTRAINTS 语句的 FOR table 选项，如下例中所示：
SET INDEXES FOR cust_calls DISABLED;
SET CONSTRAINTS FOR cust_calls DISABLED;
通过将上例中的 DISABLED 替换为 ENABLED ，您可类似地启用表的所有显式定义
的索引和隐式定义的索引，而不引用隐式定义的索引的系统生成的名称。
SET INDEXES 语句是 SET Database Object Mode 语句的一个特例。SET Database
Object Mode 语句还可启用或禁用触发器或约束，或可更改约束和唯一索引的过滤
模式。
要获取 SET INDEXES 语句的完整语法和语义，请参阅 SET Database Object
Mode 语句。
请不要将 SET INDEXES 语句与 SET INDEX 语句混淆。在当前版本中， GBase
8s 数据库服务器不理会 SET INDEX 语句。
辅助服务器上的限制
在集群环境中，在可更新的辅助服务器上不支持 SET INDEXES 语句。（一般地
说，SET Database Object Mode 语句指定的会话级索引、触发器和约束模式不被重
新指向辅助服务器的数据库中的表对象上的 UPDATE 操作。）
进入解压目录，执行安装脚本 ids_install，即可进行安装。具体命令如下：
[root@localhost ~]# cd /opt
[root@localhost opt]# sh ids_install
定制安装过程如下所示：
1.接受授权协议，内容详见 2.1.1 典型安装。
2.选择安装类型，输入 2 选择 Custom installation。
==========================================================================
=====
Installation or Distribution
----------------------------
Select the installation type.
Typical: Install the database server with all features and a database server
that
is configured with default values. Includes:
** Client Software Development Kit (CSDK)
** Java Database Connectivity (JDBC)
Minimum disk space required: 700-800MB
Custom: Install the database server with specific features and software that
you need.
Optionally install a configured database server instance.
Minimum disk space required: 75 MB (without a server instance)
->1- Typical installation
2- Custom installation
3- Extract the product files (-DLEGACY option)
4- Create a RPM package for redistribution
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS
下面所有选项，一律<回车>
==========================================================================
=====
"Choose Install Features" Help
------------------------------
On the next screen, type the number of a feature to change whether it is
selected
or
deselected.
You
can
provide
a
list
of
numbers,
separated
by
commas,
with no leading or trailing spaces.
GBase 8s 安装手册
南大通用数据技术股份有限公司
- 9 -
For example, assume that the screen contains this list:
1- [X] ABC
2- [ ] XYZ
Please choose the Features to be installed by this installer.: ___
If you want to install both ABC and XYZ, type: 2
If you want to install only XYZ, type: 1,2
PRESS
==========================================================================
=====
==========================================================================
=====
Choose Install Set
------------------
==========================================================================
=====
Choose Product Features
-----------------------
ENTER A COMMA_SEPARATED LIST OF NUMBERS REPRESENTING THE FEATURES YOU WOULD
LIKE TO SELECT, OR DESELECT. TO VIEW A FEATURE'S DESCRIPTION, ENTER
'?
1- [X] GBase database server
2- |-[X] Base Server
3- |-[X] Extensions and tools
4- |-[X] J/Foundation
5- |-[X] Database extensions
6- |-[X] Conversion and reversion support
7- |-[X] XML publishing
8- |-[X] Demonstration database scripts
9- |-[X] Enterprise Replication
10- |-[X] Data loading utilities
11- |-[X] onunload and onload utilities
12- |-[X] dbload utility
13- |-[X] Backup and Restore
14- |-[X] archecker utility
15- |-[X] ON-Bar utility
GBase 8s 安装手册
南大通用数据技术股份有限公司
- 10 -
16- |-[X] Interface to Tivoli Storage Manager
17- |-[X] Administrative utilities
18- |-[X] Performance monitoring utilities
19- |-[X] Miscellaneous monitoring utilities
20- |-[X] Auditing utilities
21- |-[X] Database import and export utilities
22- |-[X] JSON Client Support
23- [X] Global Language Support (GLS)
24- |-[X] Chinese
Please choose the Features to be installed by this installer.:
==========================================================================
=====
Feature review
--------------
Would you like to review the features that you have selected, or change which
features you have selected?
->1- Continue
2- Return to feature tree
ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS
DEFAULT:
==========================================================================
=====
Get Role Separation choice
--------------------------
Enable role separation for auditing procedures.
If you enable role separation, you can assign existing groups of users to
specific roles.
If you do not enable role separation, the database server administrator
performs all administration tasks.
1- Enable role separation
->2- Do not enable role separation
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS
GBase 8s 安装手册
南大通用数据技术股份有限公司
- 11 -
==========================================================================
=====
Server Instance
---------------
Type 'back' to go to the previous step or 'quit' to cancel the installation.
Create a database server instance?
1- Yes - create a server instance
->2- No - do not create a server instance
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS
==========================================================================
=====
Installation Summary
--------------------
Please review the following before continuing:
Product Name:
GBase Software Bundle
Install Folder:
/opt/GBASE/gbase
Product Features:
GBase database server,
Base Server,
Extensions and tools,
J/Foundation,
Database extensions,
Conversion and reversion support,
XML publishing,
Demonstration database scripts,
Enterprise Replication,
Data loading utilities,
onunload and onload utilities,
dbload utility,
Backup and Restore,
archecker utility,
ON-Bar utility,
Interface to Tivoli Storage Manager,
GBase 8s 安装手册
南大通用数据技术股份有限公司
- 12 -
Administrative utilities,
Performance monitoring utilities,
Miscellaneous monitoring utilities,
Auditing utilities,
Database import and export utilities,
JSON Client Support,
Global Language Support (GLS),
Chinese
Disk Space Information (for Installation Target):
Required: 497,274,517 Bytes
Available: 9,861,873,664 Bytes
PRESS
==========================================================================
=====
Ready To Install
----------------
InstallAnywhere
is
now
ready
to
install
GBase
Software
Bundle
onto
your
system
at the following location:
/opt/GBASE/gbase
PRESS
==========================================================================
=====
Installing...
-------------
[==================|==================|==================|================
==]
[------------------|------------------|------------------|----------------
--]
==========================================================================
=====
Installation Complete
---------------------
Congratulations! GBase Software Bundle installation is complete.
GBase 8s 安装手册
南大通用数据技术股份有限公司
- 13 -
Product install status:
GBase: Successful
GBase Connect: Successful
Main Version: GBase 8s V8.7
For more information about using GBase products, see the GBase Information
Center at http://www.gbase.cn.
PRESS
安装结束，回车，退出安装。