?
Solved

Indexed Views

Posted on 2006-11-13
3
Medium Priority
?
1,864 Views
Last Modified: 2008-02-01
Does Sybase ASE support Indexed Views? They will be used for Full-Text Search.

0
Comment
Question by:tmueller18
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 17933690
0
 

Author Comment

by:tmueller18
ID: 17934505
thanks for the link. Do you know if 12.5.3 supports it?

0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 1000 total points
ID: 17936561
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a fine trick which I've found useful many times, when you just don't want to accidentally run a batch script or the commands needs administrator rights.
What's worse than having your data encrypted by ransomware? Getting attacked by a so-called "wiper," which simply destroys the data and offers you no hope of ever seeing it again.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question