Thanks a lot....:-)

Hi everyone,

Would request, Please help or suggest me something on this issue. I will very thankful.

Regards,

Sachin.

It means when number of pages will be small.........fragmentation not follow the rule. right ?

Regards,

Sachin.

Hi Gail,

By mistake I have given you wrong table

I am using below statement in sql server to reduce fragmentation

alter index PK_JG_UserLogin on UserLogins rebuild

but in output I...

still waiting for response....

Hi,

Can someone help please........this is urgent for me.

Regards,

Sachin.

9891573054

Hi Gail,

Would request you kindly look for the same.

Regards,

Sachin.

Hi,

Please clarify below statement.

>>In the leaf level, there’s one entry...

anthony.green (2/7/2013)

dsachu (2/7/2013)

It means in your Example :

Table : Ant

Column...

It means in your Example :

Table : Ant

Column :

Name...

Then what will be Index Key in your example.

Hi

Again some confusion.

-------------------------

>> CREATE INDEX IDX_Name ON Ant (Name) - Index Key value is Name

Ant is your column right ? and Name is one record in this column

>> CREATE...

Hi,

Sorry.....actual on the basis of Gail Photo, I assume he is Mr.

----------

I have Table ABC. Where I have one Column Country id on which I have implemented primary key ....

Hi Mr. Gail Shaw,

Don't mind but i am not getting below sentence.

The key columns (also referred to as the index key) can be likened to the terms listed in a...

Gianluca Sartori (6/8/2012)

This suggests the target table is not writable.

I would check:

1) permissions

2) journaling (check this with your DB2 DBA)

3) isolation level (you usually...