Results 1 to 3 of 3

Thread: Usage of Unique Index

  1. #1
    Expert Member
    Join Date
    May 2006
    Answers
    114

    Usage of Unique Index

    Creation of Index is fine. But what is the term unique index referring to. Is it same as index. In what situation will one create this unique index? Can someone explain this by an example?


  2. #2
    Junior Member
    Join Date
    Oct 2006
    Answers
    24

    Re: Usage of Unique Index

    See creation of indexes are fine in some situation i.e when the data retrival from the table is less than 5%, otherwise a FTS is occuring there is no need of index.

    unique index and index is different, in unique index the keyword unique is used while creating index but not so in case of simple index

    in unique index the values should be unique i.e no duplicate but can exist in non unique index. A unique index can contain null values as two null values is not equal


  3. #3
    Expert Member
    Join Date
    May 2006
    Answers
    114

    Re: Usage of Unique Index

    A very detailed explanation of Usage of Unique Index . I should really thank parthokonar1 for answering me in detail.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact