Subject Ordering-Problem
I have a customers-table with a column Name (NOT NULL) and 2 indices on
this column, one ascending and the other descending. At the query which
selects from this table, I have OrderingItem
and OrderingLink
When I open the query and want to order by Name ascending, it takes
nearly a minute. With the callback-mechanism I see, that IBO fetches all
data (in this case 7000 customers) three times over the network until it
has finished.
When I order by Name descending it takes only 2 seconds, as expected.
Now I order by Name ascending again, same procedure as described above.
Any ideas, where the problem is ?