oci_bind_by_name use with

Question

Hi all,

Can you please help me understand something in this function?

From the documentation, it says if I use function oci_bind_by_name and don't define the type, it will use the default SQLT_CHR. My question is how Oracle handles this variable. Imagine I do this for a select in a table which have an index in a field of type NUMBER. Will it do a full table scan instead of an index scan?

Can someone help me understand the performance implications of not setting the type? Any other suggestions to improve performance on doing queries using PHP?