Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by Venkat Avinash only

Advanced Search

Forums
Product Launch
Updates

Today's Posts
Member List
Calendar

Home
Venkat Avinash

User Profile

Collapse

Profile Sidebar

Collapse

Venkat Avinash

Last Activity: Oct 5 '10, 12:33 PM

Joined: Oct 3 '10

Location:

Subscriptions1
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All Venkat Avinash only Visitor Messages Only Advanced

Filtered by:

new posts

Venkat Avinash replied to can i create a index using substric in DB2 9 ?

in DB2

Oct 4 '10, 01:15 PM
Hi Vijay,

To answer the actual need for this..
We have a column which is made up of different fields like
1. a indicator
2. Record number
along with them are date and time.

so, I was thinking If it is possible to create index only on 1 and 2 instead of all the fields in the column..

Also, I have checked a DB2 blog related to this..below is a link...

http://...

See more | Go to post
Leave a comment:
Venkat Avinash started a topic can i create a index using substric in DB2 9 ?

in DB2

Oct 3 '10, 10:30 PM
can i create a index using substric in DB2 9 ?

Hi,

Is below Create Index DDL Valid?

Create index index_name on table_name (substr(col1,2, 3) ASC);

See more | Go to post

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕