Sorry, that's not a very good formulation of the question.
I have 2 tables, and I want to retrieve data from records in table
A only if there are corresponding records in B. I don't care what's in the
records in table B: all I want to know is which items in A _have_ records
in B.
If I
3 times in the last few days I've had tables that have become
corrupted and needed isamchk -r to repair them. I'm becoming concerned:
what can cause such errors? (and what can I do to avoid them?)
I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
updating the
I have these tables:
table fields
a IPadd, MAC
u IPadd, MAC, user
si IPadd, deviceID, ifIndex
sf deviceID, ifIndex, MAC
For any given values of IPadd and MAC in 'a' there may or may not
be records in 'u', 'si' and
I've noticed that when developing queries involving complex joins on
tables I sometimes seem to get appallingly long times the first time I run
a query, but the second and subsequent time I run it - even substituting
a different value for a field value I'm matching on - the query runs