• Post Reply Bookmark Topic Watch Topic
  • New Topic

index information

 
shankar vembu
Ranch Hand
Posts: 309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI,
I am getting the index information for a table using DatabaseMetadata.getindexInfo(). But when I tried to find out whether the index is clustered or not using TYPE, it returns the type as DatabaseMetadata.tableIndexOther even though the index is a clustered index. It has to return DatabaseMetadata.tableIndexClustered. I am using DB2 database and the db2 driver that comes alongwith the database.Is it a problem with the driver? Can anyone clarify this.
regards,
shankar
 
shankar vembu
Ranch Hand
Posts: 309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is there any way to know whether an index is clustered or not using jdbc???
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!