Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Virtual Table and Indexes

  1. #11
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,848
    Hi Cory,

    System tables like sysindexinfo operate on databases, not directories. Ask your Centos system administrators if they can create a symbolic link to your directory from the /opt/lianja/server/data/ directory, e.g.

    Code:
    ln -s /home/cory/test/testdata /opt/lianja/server/data/testdata
    That way, you will be able to use sysindexinfo, but will not need to change your DSN.

    Regards,

    Yvonne

  2. #12
    Senior Member
    Join Date
    Jul 2013
    Location
    Ontario, Canada
    Posts
    658
    Hi Yvonne,

    Thank you for the suggestion.
    Creating the symbolic link seemed to have worked.
    The grid from sysindexinfo query now displays data.

    Now to address my last concern.
    I'm still trying to improve my data access speed.
    I apologize if I am not describing this correctly.

    How do I set (or select) an index and use a virtual table so that the virtual table query is optimized?

    Cory

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us