Skip to Content
Oracle Siebel CRM 8 Developer's Handbook
book

Oracle Siebel CRM 8 Developer's Handbook

by Alexander Hansal
April 2011
Intermediate to advanced
576 pages
11h 18m
English
Packt Publishing
Content preview from Oracle Siebel CRM 8 Developer's Handbook

Creating custom indexes

The following procedure describes how to create a custom index definition to support faster queries and sorting operations on one or more custom columns:

  1. Navigate to the S_ORG_EXT table.
  2. Check out or lock the table if necessary.
  3. In the Object Explorer, expand the Table type and select the Index type.
  4. In the Indexes list create a new record.
  5. Set the Name to S_ORG_EXT_AHA1.

    Note

    A suffix of _X will be added automatically.

  6. In the Object Explorer, expand the Index type and select the Index Column type.
  7. In the Index Columns list, create a new record with the following values:
    • Column Name: X_AHA_EXT_1
    • Sequence: 1
    • Sort Order: Asc
  8. Compile the S_ORG_EXT table.
  9. Apply the database changes (see upcoming section).

A Siebel Tools archive file (S_ORG_EXT.sif ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Implementing Oracle Integration Cloud Service

Implementing Oracle Integration Cloud Service

Robert van Molken, Philip Wilkins

Publisher Resources

ISBN: 9781849681865Other