[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1878
  • 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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