Re: Can use SQR to "update statistics on database" ?

[Pietersz Mark x8938 <mpieters@CITIPOWER.COM.AU>]

In oracle I create temporary tables and analyse them to improve performance

BEGIN-SQL
ANALYZE TABLE [$TempTableName] COMPUTE STATISTICS
END-SQL

I imagine that analyse database will be just as straight forward

Rgds

Mark Pietersz

> -----Original Message-----
> From: Korbel, Gordon E. [SMTP:GEKORBEL@NORSTAN.COM]
> Sent: Tuesday, 13 April 1999 1:37
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Can use SQR to "update statistics on database" ?
>
> I have done this successfully in sybase -- just make sure the USERID
> runnign
> the SQR has the needed permissions, and enclose the platfrom-specific
> syntax
> in a begin-sql block!
>
> Thanks,
>
> -Gordon
>
> -----Original Message-----
> From: Steve Bergin [mailto:Steve.Bergin@KAISERAL.COM]
> Sent: Thursday, April 08, 1999 9:50 PM
> To: Multiple recipients of list SQR-USERS
> Subject: Can use SQR to "update statistics on database" ?
>
>
> Database is Centure 6.1.2 PTF-4 running on Windows NT 4.0; workstations
> are
> Windows 95
> HRizon is 7.x
> SQRW is 3.x
>
> Has anyone put the "update statistics on database" database command in an
> SQR so
> the user can run it just like they run their other reports?
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This email message has been swept for the presence of computer viruses.

CitiPower Pty ACN 064 651 056
**********************************************************************