Received: from mercury.noida.hclt.com ([204.160.248.59]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA22743 for ; Mon, 29 May 2000 10:24:42 -0400 (EDT) (envelope-from jaspreet@noida.hclt.com) Received: from jaspreet (jaspreet [204.160.254.232]) by mercury.noida.hclt.com (8.8.7/8.8.7) with SMTP id TAA08006 for ; Mon, 29 May 2000 19:54:24 +0530 Message-ID: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com> From: "Jaspreet Singh" To: Subject: Embedded Vacuum sql Date: Mon, 29 May 2000 19:57:29 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0263_01BFC9A8.1ECDB670" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200005/83 This is a multi-part message in MIME format. ------=_NextPart_000_0263_01BFC9A8.1ECDB670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am a developing a PGE application in 6.5.3 using ecpg and libpq. However I am unable to Vacuum Analyze the tables using embedded sql. But t= he same command works from the prompt through vacuumdb comand. This I detect while query. My query takes 1 hr if vacuum hasn't been done o= n the database.=20 I use the following command :- "EXEC SQL VACUUM ANALYZE Kindly let me know how to use embedded sql to vacuum analyze. thanx and regards, jaspreet ------=_NextPart_000_0263_01BFC9A8.1ECDB670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
I am a developing a PGE application in 6.5.3 using = ecpg=20 and libpq.
However I am unable to Vacuum Analyze the tables&nb= sp;=20 using embedded sql. But the same command works from the prompt through vacu= umdb=20 comand.
This I detect while query. My query takes 1 hr if v= acuum=20 hasn't been done on the database.
I use the following command :-
"EXEC SQL VACUUM ANALYZE <Table Name><= /DIV>
Kindly let me know how to use embedded sql to vacuu= m=20 analyze.
 
thanx and regards,
jaspreet
------=_NextPart_000_0263_01BFC9A8.1ECDB670--