I expect the answer to be NO, but I want to try anyway (Firebird has its surprises from time to time): Is there a way to insert Blob data via a script command....
... No - Firebird supports only b*tree indexes. For more information try here: http://www.ibphoenix.com/main.nfs?page=ibp_expert1 ... I'm not quite sure what...
Some of the columns in one of my tables contain mainly nulls, others contain very few. I am trying to improve performance of a procedure which updates many ...
Hi Sergio, sorry for answering late, but I didn't have any time to try out my idea before now... Since I'm normally using Firebird 1.5, I've no experience in...
... Actually yes. Firebird will automatically cast a varchar to a blob, so just write your insert statement as if it were a varchar field. However there are...
... I built a new trigger for testing and now performance is fast on each of the columns. I'm not sure what the problem was, but it seems OK now. M....
Greets: I'm on Ubuntu using 2.1-super (Marius install). I know I'm missing something very mundane, but I've been at this for a couple days, and I can't seem to...
Hi I am trying to optimize the following count query by changing it to an exists query. I have tried various exists statements but I cannot seem to get it...
As far as I can see, you're trying to actually select an employee count by using a join with a 1-M realtionship. How could that be returned with an exists...
Hi Sorry for not being clearer. I don't need to count the employees, just find out if there is at least one per record in the tbl_job_card table ... with...
In general I've found joins to be faster than subqueries with count or exists. I guess joins are easier to optimize than the other kinds. (?) In theory, an...
I'm sure others will come up with good indexing suggestions. I don't have time to dive into that right now. Sorry. But what I usually do is to create multiple...
Also, keep an eye on index selectivity. Maybe start with updating index statistics for the indexes you already have? Kjell ... -- ... Kjell Rilbe DataDIA AB ...
... You only need an inner join to make this happen: SELECT tjc.EXCESS_PAID, tjc.JOB_CARD_ID, tjc.TIME_START, tjc.TIME_FINISH, tjc....l tjc.TIME_TAKEN, ...
Thanks Helen and Kjell Helen won't that create multiple rows if there is more than one employee? I need only one row per job card and all I'm really trying to...
With an inner join you will get one master row for each detail row, yes. I thought you wanted one row per master record, no matter what, and in one result set...
... Yes, it will, if you have multiple employees on that job card. You said "I don't need to count the employees, just find out if there is at least one per...
What I really want is this. The query must always show 1 master record irrespective of the number of detail records but there must also be a row that shows...
... This is what I've been trying to answer. But you made a typo. You meant "there must also be a *column* that shows...". Right? Kjell -- ... Kjell Rilbe ...
At 23:07 12/10/2008, Helen Borrie wrote: .... select case when (exists (select 1 from TBL_JOB_CARD_EMPLOYEE tjce where tjce.JOB_CARD_ID = tjc.JOB_CARD_ID))...
