× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2013-12-20T07:55:44Z  · last modified 2015-12-03T20:11:12Z

Support for materialized view in Sybase ASE 15.7+


customer request doc
Dev
Ivan Gron
ivangron
QA
Sachin Prakash
SachinPrakash
Priority Minor
Complexity Unknown
Component App - Visual Editing
Version 17.0

Support for materialized view in Sybase ASE 15.7+

A new feature request for Sybase ASE 15.7+ materialized views.

Take a look at 

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01165.1572/doc/html/mas1329956911672.html

 
example:
 
create table mytable (
  a int
, b varchar(20)
, constraint mytable_pk primary key nonclustered (a)
)
go
create table another (
  a int
, c varchar(10)
, constraint another_pk primary key nonclustered (a)
)
go
insert mytable select 1, 'abc'
insert mytable select 2, 'def'
insert another select 1, 'ghi'
insert another select 2, 'jkl'
go
-- To prevent:
--  Precomputed result set cannot be created as some options have an inappropriate setting. Set ansinull on, arithabort on, arithignore off and string_rtruncation on.
set ansinull, arithabort, string_rtruncation on
set arithignore off
go
drop materialized view myview
go
create materialized view myview
constraint myview_ind1 unique (a)
as
select mt.a, mt.b, ant.c
from mytable mt
, another ant
where  ant.a = mt.a
go
select *
from myview
go
insert mytable select 3, 'zzz'
go
select *
from myview
go
insert another select 3, 'yyy'
go
select *
from myview
go

 

  •  
  •  
  • 1 share
  •  
All Comments (7) Change History
Sort 

Issue #11113
Closed
Fixed
Resolved 2015-08-27T13:01:06Z
 
 
Completion
No due date
Fixed Build v17.0.0-alpha-4
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017