in reply to OT: Sql statemet (how to ignore lower-upper case)
And this still has absolutely nothing to do with Perl but I just have to say it again:
Watch out using functions like lower, upper or what not in WHERE clauses like:
pelagic
Watch out using functions like lower, upper or what not in WHERE clauses like:
Using a function in a where clause on a database column prevents the database from using any indexes. It has to apply the function to all rows first before it can decide about the selection and that's disastrous for performance if it is a big table.select name from table where lower(name) = 'fubar'
pelagic
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: OT: Sql statement (how to ignore lower-upper case)
by thor (Priest) on Dec 15, 2004 at 13:46 UTC | |
by pelagic (Priest) on Dec 15, 2004 at 14:46 UTC | |
by thor (Priest) on Dec 16, 2004 at 04:31 UTC |
In Section
Seekers of Perl Wisdom