Hi ,
This issue was replicated only on client end while I copied the DB on our end
it was working with any slowness.
I took the remote of client DB , performed validation check on DB & backup -
restore operation on DB.
After doing this its working normally now.
Thanks for help. :)
Hi All
I am trying to write something that checks if the Firebird service is
running (Windows app). On my machine (running 2.5 super classic) it
shows as 'FirebirdServerDefaultInstance'. Do other versions (super
server, FB 3.0 , 4.0) use different names for the service ?
Would I be safe
> > the multi-segment indexes are to optimize commonly used queries.
>
>In this case you can consider removing one or two fields from the index and
> see how much selectivity it lose and how much performance would be
> affected.
So, you are saying that having less fields reduces the index
Hi
the first query returns 4 rows with FK that are on VYKONY_AUT - one of them I
want to drop
the second query does not return rows
:-(
Tom