250 reputation
19
bio website blog.csdn.net/zinking3
location China
age
visits member for 1 year, 10 months
seen Apr 11 at 8:52
No mistakes

Jan
21
accepted why would rebuild index reduce btree leaf numbers
Jan
21
asked why would rebuild index reduce btree leaf numbers
Jan
20
comment Why is multiple independent index always better than concatenated index
thank you very much for clarify this.
Jan
20
accepted Why is multiple independent index always better than concatenated index
Jan
20
comment Why is multiple independent index always better than concatenated index
so the assertion in the quote isn't really valid isn't it ?
Jan
20
revised Why is multiple independent index always better than concatenated index
format
Jan
20
asked Why is multiple independent index always better than concatenated index
Jan
20
awarded  Yearling
Jan
20
accepted cross database way to force join strategies
Jan
19
comment cross database way to force join strategies
@ThomasKejser generic answer should be okay, I am not intended this for DB2 anyway.
Jan
19
revised cross database way to force join strategies
as per @ThomasKejser
Jan
19
comment cross database way to force join strategies
@ThomasKejser I was originally posting for general answers on this, but soon voted down to close because "TOPIC too broad blah blah..." I have to narrow it down. so it is preferred to talk about generic ways
Jan
17
comment how does multiple column index work in details
use-the-index-luke.com/sql/where-clause/the-equals-operator/… this is the detailed explaination on this topic.
Jan
17
comment cross database way to force join strategies
@Kondybas let me know if you want more detail, but I was intended to know talk about general mechanism of DB
Jan
17
revised cross database way to force join strategies
add more details
Jan
17
asked cross database way to force join strategies
Jan
17
comment how does multiple column index work in details
use-the-index-luke.com/sql/where-clause this is indeed a very good book
Jan
17
accepted how does multiple column index work in details
Jan
17
comment query to check all SCD tables that have data for specific date
SERVICE_LEVEL(DB2 v9.7.0.6) FIXPACK_NUM(6)
Jan
16
comment how does multiple column index work in details
I think this states that my assertion is not necessarily true. but without considering this, how does DB apply INDEX ABC on column AB join ? is that by comparing only the AB part of the index key ?