Re: Accessing rows in large tables

From: John Homeyard <homeyard_at_worldnet.att.net>
Date: 1996/05/23
Message-ID: <4o1v5i$c8p_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1


Some things to consider about indexes. Create an index if you use the column a lot in where clause, or the column has a wide range of values ie (last names). Don't index if the value range in the column is small like (yes or no). Index a column is the table is large (your 1M table qualifies) AND your query will return say 100,000 rows or less. The alternative to having no index is that ALL the data must be read for each query. Received on Thu May 23 1996 - 00:00:00 CEST

Original text of this message