Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Indexes on very small tables
Yes and no. If your table is lookup table with 100 rows then is better to create index with all table contest in it. In case that table has 3 rows no index is better. Try both ways and then collect statistics and decide what is better.
Starous Received on Fri Jul 09 1999 - 06:34:24 CDT