priya,
I would suggest do a vacuum full analyze verbose on both the tables.
and than explain analyze command to check if proper indexes are been used.
regards
gourish singbal
On 9/29/05, Hemapriya <[EMAIL PROTECTED]> wrote:
Hi,I have a query that runs fine for one set of data andnot for an
Thanks to all who responded. I'm a bit strapped for time now
so I won't publish a detailed analysis of what was wrong. Several
of the suggestions provided were helpful and more than one thing was
wrong with my setup. The program is working now on the client
machine.
Thanks again for the help.
Chris,
You're partially correct. Technically, you'd only be able to keep one
"version" of the database even though both are writable. No semaphore
or locking issues. You may do INSERT's, UPDATES, etc on either copy or
both but in the end only one may be kept. You may get around this with
synch
