Subject | using inclusive indices |
---|---|
Author | mikeevteev |
Post date | 2002-11-26T00:13:06Z |
Hi all!
I trying understand why FB 1.0 doesn't use inclusove indices.
I have simple plains selec field from table, and that field has index.
But plan shouws me full table scan.
Whats up? How I can force FB use index?
If put plan statent it gives me error that I cant use that index for
this query. But that is ridiculous!
Mike
I trying understand why FB 1.0 doesn't use inclusove indices.
I have simple plains selec field from table, and that field has index.
But plan shouws me full table scan.
Whats up? How I can force FB use index?
If put plan statent it gives me error that I cant use that index for
this query. But that is ridiculous!
Mike