Subject | Re: [ib-support] queries, indexes, and c (as an afterthought) |
---|---|
Author | Ann W. Harrison |
Post date | 2002-09-03T15:25:19Z |
At 09:09 PM 9/1/2002 +0000, jonathanmfreedman wrote:
the single column key will include blank spaces at the end of
the last name and first name. When constructing a compound key,
Firebird compresses out those spaces (suffix compression). A
smaller key is a faster key.
be written in C.
Regards,
Ann
www.ibphoenix.com
We have answers.
>can u speed up a query by creating a column that is a composite ofNo, in fact you'll probably make the retrieval slower because
>lastnamefirstnamemi and then indexing it, versus a composite index
>of lastname, firstname, mi? (one column versus three columns)
the single column key will include blank spaces at the end of
the last name and first name. When constructing a compound key,
Firebird compresses out those spaces (suffix compression). A
smaller key is a faster key.
>can u write c code in a stored procedure? or can u only call aNo, but you can call a UDF from a stored procedure and UDF's can
>stored procedure from c code?
be written in C.
Regards,
Ann
www.ibphoenix.com
We have answers.