Anyone know if you can put an index on a view (11.9.X)?

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 |
| Email: fgreco @ crossroadstech dot com |
+=========================================+

"Frank D. Greco" <fgreco@REMOVEcrossroadstechNOSPAM.com> wrote in
message news:beumgvgrtfl7muc4ni12hmcjd0ps48d07n@4ax.com...
> Anyone know if you can put an index on a view (11.9.X)?
>
> 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 |
> | Email: fgreco @ crossroadstech dot com |
> +=========================================+


No, you can't; at least not in the current versions of ASE.

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

mailto:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

No you can't.

You can create an index on the underlying base table.

--
Joop

"Soylent green is people"

Senior Consultant Sybase Professional Services
http://thedominion.cc/

"Frank D. Greco" <fgreco@REMOVEcrossroadstechNOSPAM.com> wrote in message
news:beumgvgrtfl7muc4ni12hmcjd0ps48d07n@4ax.com...
> Anyone know if you can put an index on a view (11.9.X)?
>
> 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 |
> | Email: fgreco @ crossroadstech dot com |
> +=========================================+

"Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> sez:

>"Frank D. Greco" <fgreco@REMOVEcrossroadstechNOSPAM.com> wrote in
>message news:beumgvgrtfl7muc4ni12hmcjd0ps48d07n@4ax.com...
>> Anyone know if you can put an index on a view (11.9.X)?
>>
>> 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.

Thanks Rob. I recall reading MS SQLServer allows indices on views.

Frank
+=========================================+
| Crossroads Technologies Inc. |
| Enterprise Java Engineering |
| Web: www.CrossroadsTech dot com |
| Email: fgreco @ crossroadstech dot com |
+=========================================+