Skip to Content
author's profile photo Former Member
Former Member

How to create index in schema and what is the use of index?

Hi All,

Can you tell me anybody knows..?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2014 at 12:14 PM

    Hi Sowjanya,

    Just google with 'indexes in database' and you will get unlimited amount of information.

    Have a look at these links:

    SQL CREATE INDEX Statement

    http://en.wikipedia.org/wiki/Database_index

    Regards,

    Rohit Negi.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2014 at 05:40 AM

    Hi Sowjanya,

    If you are looking for MII XML Schema, go through below post

    MII XML Schema | SCN

    About DB Index:

    Purpose


    Use the CREATE INDEX statement to create an index on:

    One or more columns of a table, a partitioned table, an index-organized table, or a cluster

    One or more scalar typed object attributes of a table or a cluster

    A nested table storage table for indexing a nested table column

    An index is a schema object that contains an entry for each value that appears in the indexed column(s) of the table or cluster and provides direct, fast access to rows.


    Oracle Database supports several types of Index:


    Normal indexes. (By default, Oracle Database creates B-tree indexes.)

    Bitmap indexes, which store rowids associated with a key value as a bitmap.

    Partitioned indexes, which consist of partitions containing an entry for each value that appears in the indexed column(s) of the table.

    Function-based indexes, which are based on expressions. They enable you to construct queries that evaluate the value returned by an expression, which in turn may include built-in or user-defined functions.

    Domain indexes, which are instances of an application-specific index of type indextype.


    About DB Schema:


    http://mysqlresources.com/documentation/db-table-schema/create-schema


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.