Hi,
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
Creating indexes, one for each field used on SELECTS,
Hi,
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
Creating indexes, one for each field used on SELECTS,
* Joao A. Marques
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
None of them beeing the primary key,