Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: Urgent:AllPages to Datapages

    Hi,

    I am having partition table GlAccounts. we have clustered index on this table.
    Currently allpages locking schema on this table. When I change the locking schema from allpages to datapages will my query result set order change.

    Is it only affect the aggregate query's/

    Could any one please help me in this.

    Thanks in advance.

    Regards,
    Arun N.

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Clustered Indexes and Sorting - While Sybase has never recommended it, some applications take advantage of the inherent sorted state of data in ALLPAGE locked tables with clustered indexes. ANSI requires the order by clause for data that is required to be ordered, but, as stated, some applications used clustered indexes to their advantage.

    In DATAROW and DATAPAGE, the concept of a clustered index is not the same and the ordering of data is not guaranteed. Therefore, any table using one of these lock models requires that order by clauses be used where data order is an application requirement.

    HTH.

Posting Permissions

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