Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    11

    Unanswered: Query Performance

    Hi Experts,

    As Sybase is column oriented database, I am trying to analyze the following 2 scenarios -
    We have a database where the system is collecting data every minutes and the amount of data in tables is huge.
    Looking at some way to create a query to help gain better performance.

    Can you help me understand which of the following query can be best suited for optimum performance where data is huge in tables -

    1. A table can have many number of columns, but of this the user is interested to see data only from certain columns.
    Creating bespoke view where we only fetch few columns from table.
    create view select col1, col2 from table

    2. We could create a new user with just select on columns they wish to see on tables using
    grant select col1,col2 on table to dcqueryuser

    Appreciate any response. Thanks.

  2. #2
    Join Date
    Sep 2012
    Posts
    11
    Appreciate any help on above query. Thanks

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    There is no difference in performance between option 1 or 2. You can use the select col1, col2, col3 from table query to retrieve the data you need. If the tabe contains a lot of records you might want to use indexes (provided you use where clauses).
    What kind of data are you collecting? And what kind of data do you want to retrieve?
    I'm not crazy, I'm an aeroplane!

Tags for this Thread

Posting Permissions

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