The use of indexes to filter tables.

The use of indexes to filter tables.

Post by Simon Thomps » Sat, 16 Dec 1995 04:00:00

Quote:Lodder) writes:

:>My conclusion is that filtering using queries and using genfilter does
:>not use secondary indexes at all. Only setRange does. This is in spite
:>of the text of the OPAL reference guide which states that you may give
:>an index name as an argument in the setGenFilter method. The setRange
:>method however is limited in it's use: it can only filter a range on 1
:>field not on 2 ranges at the same time.

This is my understanding, so it must be documanted somewhere that filters
don't use indexes. Or maybe it is onw of my third-party texts.

Can you set a range then a filter? I.e., use the range on the filter to limit
the number of records, then use the filter on that subset?

| Simon Thompson
| Christchurch
| New Zealand


1. Problems with query perfomance using the filtered indexes


I need to eliminate the indexes of deleted records from my queries. The
useful result has been achieved by using the filter expression !DELETED()
for indexes, but ...

When I using the filtered indexes with filter expression !DELETED(), then
the time needed to perform the query is growing enourmously compared to
query time with unfiltered indexes.

This database are used by several users simultaneously, which deny to use
the database indexing in runtime.

How can I make my queries to work faster?

with best regards,
Hendrik N?ulik

2. Menu Problem

3. Indexing SQL Server tables using MS Index Server

4. UniVerse on Solaris 2.6 x86 platform

5. The use of indexes to filter tables.

6. ODBC 3.1 for ORACLE V8

7. How to filter many data in filter axis when using PiovtTable10

8. VB5 performance to JET database is awful!

9. Help, Multiple Filters Using the Filter Property

10. FoxPro 2.x Free Tables/Not using Index on Tables

11. Problem with filters under Access using ODBC/SQL-tables

12. Member Filter using ADOMD in VBA for Excel XP Pivot-Table

13. Using Pivot table control/.cub filtering rather than cell security