Automatic storage of result object in queries

Asked By 0 points N/A Posted on -
qa-featured

I would like to know whether frequently used result object in queries are automatically stored for extended time or will it be necessary to use strong reference for such objects before the GC.

SHARE
Best Answer by Harpe byers
Answered By 15 points N/A #106517

Automatic storage of result object in queries

qa-featured

Hello Schyuler,

For the frequently used result object in queries to be stored automatically stored for an extended time, I guess you will need to use indexing. With the indexed, you can then build them using the scoped REF columns whereby you will use the CREATE INDEX command.

With the indices set, you can therefore efficiently evaluate queries which dereference the scoped REFs, and for such queries, they will be turned into joins implicitly. Therefore you will need to use a very strong reference for the objects that you want to access automatically to be able to implement that.

___

Regards
Clair Charles

Best Answer
Best Answer
Answered By 10 points N/A #106518

Automatic storage of result object in queries

qa-featured

Hi friend,

Yes, you will have to create strong reference or interlink your database which is technically called “indexing” in data warehouse to retrieve the data automatically and same results from the historical queries.

Please take care following steps while indexing your data warehouse:

1. Indexing depends on type of data warehouse, dimensions and facts of the relational tables, access rights etc.

2. You must set your most important business key as primary key e.g. sales invoice numbers.

3. Your partition shall be based on foreign key.

4. You shall modify your indexing time and again as frequently as your data changes to arrive at correct results.

I am sure it helped!

Related Questions