Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    47

    Unanswered: Materialized View

    Hi all,

    Am currently trying to optimize my SQL.

    Here is what I have

    drop table table-1

    drop table table-2

    create a global temp table <table-1> (on commit preserve rows option)

    create a table <table-2> based on global temp table.

    This resultant table has got 100,00 rows.

    The above two steps happens on a daily basis (drop and re-creation)

    The data source for this is a remote DB

    So, I tried to create MV for this

    so, i created a MV for corresponding global temp table
    and a MV for table-2

    This takes more time than the original procedure.

    Also,
    i tried to overcome it by doing this

    create the global temp table as in step -1
    then, MV for the resultant table.

    But this does not work as the global temp table is now empty,

    So,

    If i have some temp tables how can i create a MV based on this

    Please let me know the best possible way to achive this both is terms of optimized run as well as min. time.

    Hope Am clear.

    Thanks

    Sundar

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    What are you really trying to do?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •