unique index and non unique index

Dear friends,

Any body tell me what is the difference between unique index and non unique index?

I want briefly explantation..

Expecting your replies..

Hastha23

May 24 '07 #1

Subscribe Post Reply

3980

MMcCarthy

14,534

Expert Mod 8TB

Hastha,

The answers to these kind of questions are freely available on the web. Posting repeated questions for this kind of simple definitions seems to be homework related and this site has very strict guidelines on the posting of and answering homework questions which I would advise that you read carefully.

These kind of definition questions clutter up the forum and the information you are looking for can be found in numerous places on the web. The answer to this one is simply that a unique index won't allow for duplication of values wheras a non-unique index will.

Please search the web thoroughly for answers to these kinds of questions before posting them in this forum. The experts will get very impatient with members who repeatedly ask these kinds of questions.

ADMIN

May 25 '07 #2

Similar topics

Unique row question

by: Laphan | last post by:

Hi All I know you can set a row to be unique, but I want expand on this in that I want the DB schema to only disallow an entry if the row isn't unique across 3 fields. Is it possible? My DDL...

MySQL Database

Unique Index for two columns in a table

by: June Moore | last post by:

Hi, I would like to add a unique index that consists of two fields in a table. e.g. tbl_A (field1,field2) -- field1 & field2 Indexed and combination must be Unique. Can anyone tell me the...

Microsoft SQL Server

unique constraint vs unique index in MS SQL 2000

by: Kamil | last post by:

Hello What should I use for better perfomance since unique constraint always use index ? Thanks Kamil

Microsoft SQL Server

Use variables to get unique nodes

by: Rolf Kemper | last post by:

Dear Experts, I got stuck with the following problem and need your help. What I wnat to do is to get a set of distinct nodes. Before the distinct I have selected the multiple occourences...

.NET Framework

primary =/=> unique?

by: Bob Stearns | last post by:

I was under the impression that the primary key had to be a unique index. Since I usually create my primary indices before my primary keys, in order to get the indices in the same schema as their...

DB2 Database

Difference between unique constraint and unique index?

by: aj | last post by:

DB2 WSE 8.1 FP5 Red Hat AS 2.1 What is the difference between adding a unique constraint like: ALTER TABLE <SCHEMA>.<TABLE> ADD CONSTRAINT CC1131378283225 UNIQUE ( <COL1>) ; and adding a...

DB2 Database

unique constraint and unique index

by: Laurence | last post by:

Hi there, How to differentiate between unique constraint and unique index? These are very similar but I cannot differentiate them? Could someone give me a hand? Thanks in advance

DB2 Database

Primary Key Vs Unique Index in DB2

by: vj_dba | last post by:

Hi Group, I have a Primary key in my table. It's clear Primary key wont allow duplicates, this primary key creates one index for retrival. Suppose if my table is having a Unique index also....

DB2 Database

Unique Index or PK ?

by: p175 | last post by:

What are the advantages / disadvantages of having primary keys in lieu of ordinary indexes ? If there are no foreign relationships defined, is it better to have a two column index allowing reverse...

DB2 Database

Can I create unique index on selected records ?

by: Alvin SIU | last post by:

Hi all, I have a table in Db2 v8 like this: Team Name Role ------ -------- --------------------- A Superman Leader A Batman Member A WonderWoman Member B ...

DB2 Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing