SwissDelphiCenter.ch : ...regenerate all out-of-date indexes on a given table?

whats new ¦ programming tips ¦ indy articles ¦ intraweb articles ¦ informations ¦ links ¦ interviews
misc ¦ tutorials ¦ Add&Win Game

Tips (1541)

Database (90)
Files (137)
Forms (107)
Graphic (114)
IDE (21)
Indy (5)
Internet / LAN (130)
IntraWeb (0)
Math (76)
Misc (126)
Multimedia (45)
Objects/
ActiveX (51)
OpenTools API (3)
Printing (35)
Strings (83)
System (266)
VCL (242)

Top15

Tips sort by
component

Search Tip

Add new Tip

Add&Win Game

Advertising

...regenerate all out-of-date indexes on a given table?
Autor: invisible
[ Print tip ]

Tip Rating (2):

procedure TForm1.Button1Click(Sender: TObject);
begin
  Table.Close;
  Table.Exclusive := True;
  Table.Open;
  DbiRegenIndexes(Table.Handle);
  Table.Close;
end;

Rate this tip: