by Frank D. Grec » Thu, 10 Jul 2003 11:13:54
I tried searching the (really slow) Sybase website but
wasn't having much luck. Google wasn't that helpful either.
Thanks,
Frank
+=========================================+
| Crossroads Technologies Inc. |
| Enterprise Java Engineering |
| Web: www.CrossroadsTech dot com |
+=========================================+
by Rob Verschoo » Thu, 10 Jul 2003 15:58:00
> I tried searching the (really slow) Sybase website but
> wasn't having much luck. Google wasn't that helpful either.
> Thanks,
> Frank
> +=========================================+
> | Crossroads Technologies Inc. |
> | Enterprise Java Engineering |
> | Web: www.CrossroadsTech dot com |
> +=========================================+
HTH,
Rob
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5
New book(coming soon): 'Tips, Tricks & Recipes for Sybase ASE'
For details, see http://www.sypron.nl/ttr
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
by species847 » Thu, 10 Jul 2003 16:15:01
You can create an index on the underlying base table.
--
Joop
"Soylent green is people"
Senior Consultant Sybase Professional Services
http://thedominion.cc/
> I tried searching the (really slow) Sybase website but
> wasn't having much luck. Google wasn't that helpful either.
> Thanks,
> Frank
> +=========================================+
> | Crossroads Technologies Inc. |
> | Enterprise Java Engineering |
> | Web: www.CrossroadsTech dot com |
> +=========================================+
by Frank D. Grec » Fri, 11 Jul 2003 12:03:19
>> I tried searching the (really slow) Sybase website but
>> wasn't having much luck. Google wasn't that helpful either.
>No, you can't; at least not in the current versions of ASE.
Frank
+=========================================+
| Crossroads Technologies Inc. |
| Enterprise Java Engineering |
| Web: www.CrossroadsTech dot com |
+=========================================+
1. Problems creating index on a view
Can you post your view definition & the CREATE INDEX statement
you use? Which interface are you using?
--
- Anith
2. Can not Restore from Dump Device where field type = Text Error
4. Next version of SQL after 2000.
5. How to put index on the views with self-join
6. Looking for alternative for APB
7. Indexed Updatable Partitioned Views?
10. Full-Text Indexing with Partitioned Views in SQL 2000
11. Index on a View
12. Full-text index for a view
13. Indexed Updatable Partitioned Views?