|
|
Posted by hubmei75@web.de on 01/14/06 17:55
Hello,
I have a simple table containing adresses.
A sample view of the table is
id name city
--------------------------------
100 Meier New York
101 Meier Tokyo
110 Olson Amsterdam
110 Olson Dublin
111 Paul Berlin
...
The view is ordered by (name,city)
Now my problem:
I want to see only the second half of the view
starting from "Olson" in "Dublin"
Using the constraint
where (name>="Olson") and (city>="Dublin")
does not the right thing. It eliminates i.e. row 111.
The only idea I have is to concatenate the fields to
simulate the compound index to be able to do
where name+"~"+city>="Olson~Dublin"
not to forget to struggle with null fields to get
the right results. This slows down the simple query
dramatically.
This seems to be a complicated solution for a simple
problem, given the fact, that the index is already
available at the server.
Does anyone has an idea or suggestion?
-Hubert
Navigation:
[Reply to this message]
|