New answers tagged sybase
When you have two separate indexes on transact and on transactchild the server can't use them efficiently when searching for (t.rid=blk.transact OR t.rid=blk.transactchild). The classic way to handle this type of OR search is to split it into two simple searches and then UNION results together. So, you can try something like this: SELECT .... FROM ... ...
Top 50 recent answers are included