        _____________559

  ,  

Select ... ORDER BY pl,p3

    .

     Create Index:

CREATE INDEX < > ON <  > < >
:

CREATE INDEX depyear ON Pers Dep, Year_b

     Drop Index:

DROP INDEX <  >.< >
:

DROP Index Pers.depyear

           -
,         -
  .        
      
:

ALTER INDEX < > DEACTIVATE
ALTER INDEX < > ACTIVATE

      ,    
    .

10.1.6  Query

10.1.6.1  

    SQL.  ,   
   .      -
  TQuery.      ,   Tab-
le,   Query        
Table.   Query    -
   SQL.

   Query,   C++Builder    -
    Query, DataSource, DBGrid.   DataSet -
 DataSourcel  Queryl,    DataSource  DBGridI
 DataSourcel.  ,    :  
(Queryl),   (DataSourcel),    
 (DBGridI).       Query.

   Query  SQL,   TString.  -
 ,   SQL.    
 ,    ,     -
   SQL,   ,    
   .      
 SQL    ,   
TString: Clear  , Add     ..

  Query     
,      ,    
  .    .

10.1.6.2   Query

  DataBaseName  Query  ,    
  Table,  ,     . 