On Thu, 2002-04-25 at 08:42, Luis Alberto Amigo Navarro wrote: > > > > (2) Use programmatic hints which allow coders specify which indexes are > used > > during a query. (ala Oracle) > > > As I said before it would be useful a way to improve(not force) using > indexes on particular queries, i.e. lowering the cost of using this index on > this query. > Regards
I was told that DB2 has per-table (or rather per-tablespace) knowledge of disk speeds, so keeping separate random and seqsqan costs for each table and index could be a good way here (to force use of a particular index make its use cheap) ------------ Hannu ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
