Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2

    Unanswered: Sybase IQ Index Deleted

    Hi ,

    Using Sybase 15.4,
    1.when I create an index on a column having data,do I need to do any further action to make effect of that index?

    2.Whenever truncate table executed , it truncates indexes also..
    Can anybody give suggestions on this pls...


    Thanks,
    Yuvaraj.S
    Yuvaraj Subramani

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,
    A truncate that deletes indexes?
    I find that hard to believe, for that index to dissapear, you must have some other process removing it.

    From sybase documentaion on IQ 15.4
    TRUNCATE TABLE is equivalent to a DELETE statement without a WHERE clause, except that each individual row deletion is not entered into the transaction log. After a TRUNCATE TABLE statement, the table structure and all of the indexes continue to exist until you issue a DROP TABLE statement. The column definitions and constraints remain intact, and permissions remain in effect.
    1- You create an index and its in effect. Just keep it up to date.
    2- Well yes the index has no rows to "index" anymore, but it still exists.

  3. #3
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2
    Hi Catarunnus,

    got to know Developers dropped and recreated that table....
    Making Indexes upto date? how ?
    Yuvaraj Subramani

  4. #4
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    The developers have populated the new recreated table?

    If yes, and if the indexes are created after the data is in, then yes they are up to date.

    If no indexes are created before data in, they need to update statistics after the data is inserted.


    Last edited by Catarrunas; 02-04-14 at 11:15.

Posting Permissions

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