Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1892
  • Last Modified:

Indexed Views

Does Sybase ASE support Indexed Views? They will be used for Full-Text Search.

0
tmueller18
Asked:
tmueller18
1 Solution
 
leonstrykerCommented:
0
 
tmueller18Author Commented:
thanks for the link. Do you know if 12.5.3 supports it?

0
 
Joe WoodhousePrincipal ConsultantCommented:
It doesn't.

ASE 15.0.x does support functional indexes, ie. indexes on expressions and/or derived columns, which could give you some of what you're looking for.

The bundled Full-Text Search engine will significantly outperform ASE's text searching and indexing.

Another thing to consider is Sybase IQ. It is less mature than ASE, and needs more work to understand, but the gains in disk compression, indexing and query speed simply aren't believed by most people. 8-) It has some text-specific indexes which could be very useful to you. Note, it's more expensive than ASE though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now