index_G

G

Global indexes, 88-89

defined, 88

illustrated, 89

SQL code for creating, 89

See also Partitioned indexes

GRANT command, 389

Graphical user interface (GUI) tools, 29

Graphs, 468-70

data display, 468

drill-down capability, 470, 471

example, 470

illustrated, 469

layout specification, 469

Graph Wizard, 326

GROUP BY clause, 111, 172

in materialized view query, 144

query rewrite with, 190-91

GROUPING function, 107-9

behavior, 107

defined, 107

uses, 108

values, 107

See also SQL functions

GROUPING_ID function, 108-9

GROUPING SETS function, 104-7

capability, 105

concatenated, 106

defined, 102

multiple, specifying, 106

with supported aggregates, 103

See also SQL functions

Groups

creating, 334-35

defined, 334

illustrated, 335