Indexing for SQL complient Views on Unidata v4

Indexing for SQL complient Views on Unidata v4

Post by CLeigh19 » Tue, 11 Mar 1997 04:00:00

I am attempting to a EIS system to work with Unidata. I have managed to
create the views for the S,MV and MS attribs but the indexing appears all
messed up.

For testing purposes I have truncated the files and everything works fine.
When I point the EIS system it really strugles to return data. This I feel
is because the values in the tables are split over 2 or 3 classes in my
EIS system.

So does anyone out there know how I can establish if the Indexing is
working correctly. If they are not how do I get them to work?

I am running Unidata 4 on our test machine a Motorola 8640. Uniserver is
version 2 and the ODBC drivers are the 32bit version 2 drivers. The EIS
system I am using is Business Objects. I have created the views using
Schema API and not VSG.

If anyone out there can help I would be most gratefull.




1. BDE Replacement thats SQL Complient?

I'm currently look for a database for Delphi v1.0 (yes 16-bit) that allows
access to it's tables using ALL the native Delphi database components.  
Especially TQuery.

Currently Paradox/Dbase support is far too slow due to not being able to use
Secondary indexes in your queries, and Interbase is fast becoming a pain when
you need multi-user support.

I have see several good replacements out there for Access/Btrieve/FoxPro etc.
however the are either not SQL complient, or for 32-bit only.

Does such a beast exist, or am I just stuck with Interbase?

Andrew H. Grilk
Securities Data Company Inc.
Newark, NJ

2. FOXPRO Report Writer (1.02/2.0)

3. DBexport V4.1 create view problem

4. Can't Print Data Model Diagram

5. Odbc v4.0 (v4.0.4028.0)

6. pgsql/src/backend/parser analyze.c

7. Oracle8.0.3 for Digital V4.0.a-V4.0.c

8. sp_MSforeachDB and sp_spaceused

9. ACE Report Compiler Problem v4.0x to v4.1x

10. Wanted To Buy: FMPro Win v4.0 or v4.1

11. MS XML Parser v4.0 on NT v4.0

12. Indexed views - mechanism of auto update of the contents of the view

13. Indexed view doesn't appear to be using index on queries