Subject | FB: Cross db queries, temp tables etc |
---|---|
Author | oneway_111 |
Post date | 2002-08-28T00:57:58Z |
Hi,
Couple of Qs:
1) Does FB support cross-db queries?
2) Does FB have anything similar to Sybase temp tables?
3) Is it possible to restrict execute permission on a stor proc to
certain users/groups?
4) Does FB create SP's execution plan only once or every time SP is
executed?
5) JDBC: If PreparedStatement is executed in a loop, will it be
re/compiled when it's prepared or every time it is executed?
Thanks in advance
Couple of Qs:
1) Does FB support cross-db queries?
2) Does FB have anything similar to Sybase temp tables?
3) Is it possible to restrict execute permission on a stor proc to
certain users/groups?
4) Does FB create SP's execution plan only once or every time SP is
executed?
5) JDBC: If PreparedStatement is executed in a loop, will it be
re/compiled when it's prepared or every time it is executed?
Thanks in advance