From: Helen B. <he...@tp...> - 2008-03-24 23:30:57
|
At 10:13 AM 25/03/2008, you wrote: >> (Helen) 1. The index isn't available if you use LIKE. >No. If I execute the query out of the procedure and have a look of the performance analysis (shown from IB-Manager from EMS) the query was executed by using indexreads :-). This looks like using the index to me - or not? If the index used is the one on SuchName then the LIKE predicate has been transformed into STARTING WITH by the DSQL engine. This will happen automatically with LIKE 'astring%'. But you can make that work unnecessary by using STARTING WITH yourself. >> 3.(Helen) A cursor is much faster than a subquery >Good idea. This looks nice. I will test it tommorow morning. > > for select IDPerson from personen > where SuchName STARTING WITH :SuchName1 > into :v_idperson > do > insert into HilfeListe(ID,Bereich) > values (:v_idperson, :bereich); > > >> (Helen) 4. This is a firebird-support question. >You are right. Please give me a link to an activ group (like this :-)) http://firebirdsql.org/index.php?op=lists gives you all of the groups and their rules and purposes. >By the way. Is there any full documentation of the statements availible?. >I often use an old documentation for Interbase. I get it from Borland 10 years ago :-) and found i on internet too. That's OK, the original language hasn't been removed. ;-) You would do better to join the correct group for your SQL questions...and to put the release notes in a handy place. If you want everything in one document, there IS a book you can buy.... You're straying further and further away from .NET Provider issues. Helen |