DB2 Cost : index of articles
I started a series of articles concerning the cost of queries (and as a consequence concerning the choices the optimizer […]
Cost, DB2, Explain, Index
Index
Cost, DB2, Index
DB2 : Cost Calculation 2 : index only
Index Why indexes Searching through millions of rows can be the right thing to do (TBSCAN). It might be the […]
Index, Oracle
Index Full Scan
Index index I would like to see all values of N, but I would like to see them in order. […]
Index, Oracle
Index Fast Full Scan
Index index Today I want to query our table again. We alter the table so column N is not null. […]
Index, Oracle
INDEX FULL SCAN (MIN/MAX)
Index index Another way an index can be used to access a piece of data: Index Full Scan (Min/Max) If […]
Index, Oracle
Index Range Scan
Index index OK, let’s talk about the Index Range Scan. The word range reflects that Oracle will scan through (a […]
Index, Oracle
Index Unique Scan
Main Post The Index Unique Scan is used when one unique piece of information (row) is needed. A primary key […]
Index, Oracle
Index_demo data setup
In a number of posts about indexes I use a demo table with some indexes. Here is how it is […]
Index, Oracle
Index usage
Let’s talk a little about the usage of indexes. Following access paths are considered: Index Unique Scan Index Range Scan […]